Skip to content

Registered aircraft · 3,961

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-21-02-R1') 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-21-02-R1') 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-21-02-R1')
    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-21-02-R1')
  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-21-02-R1')
  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-21-02-R1')
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.

N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136 N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N567Herr John Robert · Saint Petersburg, FLFirst renewal noticeBuilt 1972 · S/N 310Q0459 N567CWPlane Fun Inc Tr Trustee · Snellville, GAS/N 0076 N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713 N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218 N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221 N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252 N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222 N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425 N569PAHerron Aviation Group LLC · Dexter, MIS/N 414A0461 N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422 N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847 N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941 N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067 N56MELuttrell Jabe · Key West, FLBuilt 1977 · S/N 340A0316 N56RXKing Cobra Investments LLC · Rancho Cordova, CABuilt 1976 · S/N 421C0207 N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804 N56VPGoulette Bryan · Fort Worth, TXBuilt 1961 · S/N 320-0036 N5701MConsulat Inc · Cheyenne, WYS/N 310P-0001 N5701XCoan Mark A · Berthoud, COBuilt 1961 · S/N 320-0001 N5709MClear Blue Western Sky LLC · Anthem, AZBuilt 1968 · S/N 310P-0009 N570EK & D Air LLC · Morgan City, LABuilt 1975 · S/N 310R0175 N5711MSwager Joel P · Ione, CAS/N 310P0011 N5712MDay Star Aviation Inc · Locust Grove, GABuilt 1968 · S/N 310P0012 N5714XKulon Andrew · Wyanet, ILS/N 3200014 N5715MExpress Air LLC · Wilmington, DEBuilt 1968 · S/N 310P0015 N5716XFlanegan Charles E Jr · Jonesboro, GABuilt 1961 · S/N 320-0016 N5720MSongbird Aviation Inc · Lawrenceville, GABuilt 1968 · S/N 310P0020 N5721MWood Michael D · Huntington Beach, CABuilt 1968 · S/N 310P0021 N5721XRichardson John L · Anchorage, AKS/N 320-0021 N5729MN5729m LLC · Coral Springs, FLBuilt 1972 · S/N 340-0038 N5731MZortman Micky P · Mexico, MOS/N 310P0031 N5731XLife Is Flying Inc · Deerfield Beach, FLBuilt 1961 · S/N 320-0031 N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040 N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041 N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042 N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046 N5746X300 Series Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 320-0046 N5751CRemy H Blanchaert Jr Dds Md Pa · Wichita, KSS/N 340A0974 N5752MColeman William J · Redondo Beach, CABuilt 1968 · S/N 310P0052 N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975 N575HBHot Damn Flying Service LLC · Palm Coast, FLBuilt 1973 · S/N 310Q0788 N575JBForbes Consolidated Inc · New Smyrna Beach, FLS/N 414A0426 N575RCRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 4040431 N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268 N5762MNewby Aviation LLC · Pingree Grove, ILBuilt 1968 · S/N 310P0062 N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063 N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065

Back to AD 87-21-02 R1