Skip to content

Registered aircraft · 54,015

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.

N7331XPorter H Tom · Columbia, MSS/N 15059431 N73321Learn To Fly Nola LLC · New Orleans, LABuilt 1976 · S/N 17267372 N73324Gulf Atlantic Airways DBA · Gainesville, FLBuilt 1976 · S/N 17267374 N7332MNorthern Flyers LLC · Bemidji, MNS/N 55632 N7332SSmith Enterprises Inc · Grangeville, IDBuilt 1976 · S/N 18265123 N73330Thornton Ralph · Oxford, ALBuilt 1976 · S/N 17267378 N73331Dameron Cleveland F · Wicomico Church, VABuilt 1976 · S/N 17267379 N73334Heavy Metal Air LLC · Farmingdale, NYBuilt 1976 · S/N 17267382 N73338Einarson Flying Service · Intl Falls, MNS/N 17267386 N7333FHickle William H · Inyokern, CAS/N 17273246 N7333QMac Neill Malcolm G · Lake Junaluska, NCBuilt 1972 · S/N 18260973 N7333TMyl High Flying Club LLC · Mccall, IDFirst renewal noticeBuilt 1959 · S/N 46933 N7333XFrederick Aero Development Inc · Murrieta, CABuilt 1977 · S/N R18200080 N7333YMayotte Stephen A · North Chelmsford, MABuilt 1977 · S/N R18200116 N73345N73345 Aviation LLC · Sheridan, WYBuilt 1976 · S/N 17267390 N7334FWings Flight Enterprises Inc · Danville, KYBuilt 1979 · S/N 17273247 N7334GEllis Gregory D · Winnsboro, TXBuilt 1970 · S/N 17259034 N7334KFlying Wet Dog LLC · Marshall, TXBuilt 1976 · S/N R1722058 N7334NRobles James J · Oro Valley, AZBuilt 1976 · S/N U20603616 N7334PUp And Away Aviation LLC · Poughkeepsie, NYS/N P21000004 N7334QHurri-Clean LLC · Brewton, ALBuilt 1972 · S/N 18260974 N7334SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265125 N7334THunter Jeffrey D · Wolfforth, TXBuilt 1959 · S/N 46934 N7334XElliott Frank F · Mojave, CABuilt 1961 · S/N 15059434 N73354Sky Partners LLC · Sylacauga, ALBuilt 1976 · S/N 17267396 N73357Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 17267398 N7335APomeroy Keith R · Port Saint Lucie, FLS/N A1500721 N7335GJordan Jeffrey B · Woodland, WABuilt 1970 · S/N 17259035 N7335NEnrique Elias Luis · Chandler, AZS/N 21063221 N7335QStaas Justin W · Sacramento, CABuilt 1972 · S/N 18260975 N7335TNever Repress Laughter LLC · Villa Rica, GABuilt 1977 · S/N R18200029 N7335XTowery Katy L · Dover, DES/N 15059435 N73361Snyder Steven S · Norfolk, VABuilt 1976 · S/N 17267400 N73362Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17267401 N73365Toliver David R · Lenexa, KSS/N 17267404 N73367Martinez Jose Antonio · Orlando, FLBuilt 1976 · S/N 17267406 N7336ARanger Aviation Inc · Burlington, COBuilt 1957 · S/N 29436 N7336BWild Robert · Woodbury, NJBuilt 1977 · S/N A1520750 N7336CDelta Kilo Av8 LLC · Bonita Springs, FLS/N 21063938 N7336HGerace William L · Anchorage, AKBuilt 1977 · S/N 18503366 N7336MYates Christopher Lynn · Edmond, OKS/N 55636 N7336NRoberts Frederick · El Segundo, CABuilt 1974 · S/N 18263120 N7336SAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 18265127 N73370Bay Flying Services LLC · Pinconning, MIBuilt 1976 · S/N 17267408 N73371Elliott Aaron · Scott City, KSBuilt 1976 · S/N 17267409 N7337GReiss Alan T · Puyallup, WABuilt 1970 · S/N 17259037 N7337KPurin Corp · Mechanicsville, IAS/N R1722059 N7337MRexwinkle Thomas L · S Coffeyville, OKBuilt 1958 · S/N 55637 N7337NSpitfire Aviation Inc · Wilmington, DEBuilt 1974 · S/N 18263121 N7337QCopper Ridge Express LLC · Iowa Falls, IABuilt 1978 · S/N R18200271

Back to AD 87-20-03 R2