Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N4778FPond Engineering Laboratories Inc · Berthoud, COBuilt 1967 · S/N P206-0378 N477JGulf Airbatics Ltd · Jennings, LABuilt 1966 · S/N TE-108 N477MAThompson Layne A · Pollok, TXBuilt 1981 · S/N 21064291 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477 N477RBNwl Capital Holdings LLC · Black Eagle, MTBuilt 1974 · S/N D-9685 N477RSSundbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0477 N477WCAllison Medical Solutions LLC · Lumberton, MSBuilt 1977 · S/N E-1065 N4780RR&R Flight Services Inc · Mendota, ILBuilt 1975 · S/N 18802319 N4781QStocker Russell · Woodland, CAS/N 18802523 N4783KLandwehr Wayne A · Gill, COBuilt 1979 · S/N P21000314 N4784FSullivan Ross Anthony · Saint Helena, CAS/N P206-0384 N4785UNew England Vascular Access LLC · Bristol, NHBuilt 1983 · S/N 21064816 N4786FLogan Robert E · Advance, NCBuilt 1968 · S/N P206-0470 N4786QMcgregor Daniel A · Denali Park, AKBuilt 1978 · S/N 18503556 N4788PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P21000108 N4789FGrimes Aero LLC · Hobbs, NMBuilt 1967 · S/N P206-0389 N478CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2002 · S/N 0400 N478EHighland Holdings LLC · Helena, MTBuilt 2018 · S/N E-4122 N478GRabkin John M · Portland, ORBuilt 2004 · S/N 1227 N478SEGarber William · Apollo Beach, FLFirst renewal noticeBuilt 2004 · S/N 1158 N478TFoster Theresa A · Scurry, TXBuilt 1964 · S/N D-7649 N4790FKise Scott T · Circle Pines, MNBuilt 1967 · S/N P206-0390 N4791FPfp Aviators LLC · South Salt Lake, UTBuilt 1967 · S/N P206-0391 N4791UAerialtraders LLC · Fort Myers, FLBuilt 1979 · S/N U20605104 N4794FGet Out Aviation LLC · Palmer, AKBuilt 1967 · S/N P206-0394 N4795CPrecision Design Inc · Wilmington, DEBuilt 1979 · S/N 21063629 N4795FClark Joseph D · Kilgore, TXBuilt 1967 · S/N P206-0395 N4795QHinkle Airspray Inc · Cavalier, NDBuilt 1976 · S/N 18802534T N4796K96k LLC · Cave Creek, AZBuilt 1979 · S/N P21000323 N4796MN4796m LLC · Norridge, ILBuilt 1978 · S/N D-10133 N4797UPhilbrick Rodney C DBA · Bishop, CABuilt 1979 · S/N U20605108 N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012 N4798KAmerican Diversified Services LLC · Marietta, GABuilt 1979 · S/N P21000325 N4798PShepherd Mike · Amarillo, TXBuilt 1978 · S/N P21000112 N4799CFlying Horse LLC · Missoula, MTBuilt 1979 · S/N 21063632 N4799VDeparture Aviation Services LLC · Laurel Hill, NCS/N 30088 N479BAJml Aviation Inc · Jonesboro, ARBuilt 2014 · S/N E-4056 N479HBDouble Bar Stationair LLC · Coeur D Alene, IDBuilt 1975 · S/N U20602923 N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801 N479SVKollstedt Lance S · Tipp City, OHBuilt 1979 · S/N 79-30950 N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114 N47APAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 1983 · S/N U20606768 N47BCBrentech Leasing LLC · Cartersville, GABuilt 1988 · S/N 4608129 N47DBCala Brush Supply Inc · Weslaco, TXBuilt 1978 · S/N P21000175 N47FAAshe Olen Reid Jr Trustee · Winston Salem, NCBuilt 2004 · S/N 0965 N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207 N47JDQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 421C0805 N47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARBuilt 1973 · S/N D-9432 N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530 N47KKHermansen Dane K · Ormond Beach, FLBuilt 1983 · S/N T30300216

Back to AD 86-13-04 R3