Registered aircraft · 54,017

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3696CTb Services LLC · Huntsville, ALBuilt 1978 · S/N R18200313 N3697LShearair LLC · Valparaiso, INS/N 17253866 N3697SRossi Michael · Big Pine, CABuilt 1963 · S/N 17250897 N3698CTomlinson John J · Kent, WABuilt 1954 · S/N 31197 N3698JWise Tammy B · Eden, NCBuilt 1966 · S/N 15064998 N3698UJk Fly LLC · Abie, NEBuilt 1963 · S/N 18255098 N3699JBlock Time Bandits LLC · Boise, IDBuilt 1966 · S/N 15064999 N3699YAmfreight Logistics LLC · Deltona, FLBuilt 1963 · S/N 21058199 N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479 N369CBHahn Mitchell S · Chagrin Falls, OHS/N 182-66699 N369CMOharra Robert J · Buckley, WABuilt 1969 · S/N 18052058 N369ERTower Aviation Management LLC · Decatur, TXFirst renewal noticeS/N 172RG0062 N369GBStork 1 LLC · Green Cove Springs, FLBuilt 1981 · S/N 15285103 N369GTTokar Gary J · Howell, MIBuilt 1960 · S/N 52608 N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049 N369JJB&B Aviation LLC · Evansville, INBuilt 1950 · S/N 7510 N369KSkydive Inc · Eagle Creek, ORBuilt 1963 · S/N 18254634 N369MBBarnes Matthew L · Pacific Palisades, CABuilt 1979 · S/N 18266986 N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N36AFLewis Richard M Jr · Deltaville, VABuilt 1977 · S/N R18200104 N36APAnalysis Inc · Grand Junction, COBuilt 1971 · S/N 18052206 N36CCPittsburgh Marine Technologies Inc · Eighty Four, PAS/N 15283484 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36GBSmokey Bay Air Inc · Homer, AKBuilt 1972 · S/N U20601854 N36GRRiethof George N · Nantucket, MABuilt 1978 · S/N 17272026 N36JCSafety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 17261759 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36MJFinland Leasing Co Inc · Quakertown, PABuilt 1980 · S/N 18504104 N36MSFlying Medical Service Inc · Grosse Pointe, MIBuilt 1976 · S/N U20603244 N36NHAlgar Linda · Tucson, AZBuilt 1980 · S/N 18267589 N36RCAiken Air Sales And Rentals LLC · Aiken, SCBuilt 1970 · S/N 18260311 N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691 N36SBWollenberg Jeffrey · Concrete, WABuilt 1956 · S/N 32271 N36SKFortin Jean T · Mechanicville, NYBuilt 1963 · S/N 17250459 N36STGriffith Joshua S · Breckenridge, TXBuilt 1979 · S/N 18267282 N36TDThayer Kenneth R · Bonita Springs, FLBuilt 1971 · S/N 15073090 N36WYFlexible Flyer LLC · Cody, WYBuilt 1977 · S/N 18503311 N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650 N36XBSchmidt Thomas P · Nunica, MIBuilt 1956 · S/N 33049 N36XCHangar C-403 LLC · Walnut Creek, CABuilt 1979 · S/N 18267223 N36ZNDawkins Christopher R · Trinity, NCBuilt 1970 · S/N 18501830 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N3700JOluoch Bill Rachuonyo · San Francisco, CABuilt 1966 · S/N 15065000 N3700SMusket Air LLC · Page, AZBuilt 1963 · S/N 17250900 N3700URydberg Lawrence · Albuquerque, NMBuilt 1963 · S/N 18255100 N3701LRice Solutions LLC · Plymouth, NHS/N 17253870

Back to AD 87-20-03 R2