Skip to content

Registered aircraft · 68,369

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N26651Edwards Joseph Morton III · Monument, COBuilt 1940 · S/N 1993 N26653Lairson David W · Dayton, TXBuilt 1940 · S/N 1995 N26655Weyhe Joan Monica · Medford, ORBuilt 1978 · S/N AA5A0623 N2665BSteria Kermit J · Monahans, TXBuilt 1956 · S/N 374 N2665MProsser William C · Wasilla, AKBuilt 1947 · S/N 12-993 N2665ZRegistered aircraftBuilt 1978 · S/N 351-78 N26661Barber William M · Alden, MIBuilt 1978 · S/N AA5A0547 N26664Grumman N26664 LLC · Charlotte, NCBuilt 1977 · S/N AA5A-0518 N2666MBurt David R Jr · Justin, TXBuilt 1946 · S/N 12-1109 N2666PBerentson Bradley J · Westhope, NDBuilt 1955 · S/N 18-4390 N2666ZBig Falls Flying Club Inc · Intl Falls, MNS/N 1224-78 N26670Ward John L · Mexia, TXBuilt 1978 · S/N AA5A0628 N26675Kilmurry Thomas · Charlotte, NCBuilt 1978 · S/N AA5A0639 N26677Meinen Max W · Grandview, TXBuilt 1940 · S/N 2019 N26679Kennann Christopher D · Lubbock, TXS/N AA5A0641 N2667WMartens Steven A · Stanley, NDBuilt 1966 · S/N 670024 N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78 N26680Dec James T · Cayuga, NYBuilt 1940 · S/N 2022 N26683Stinebring Brad L · Columbus, INBuilt 1940 · S/N 2025 N26684Stanard Paul J · Moreland Hills, OHBuilt 1978 · S/N AA5A0644 N26685Le Pendu Claude E · Fruit Heights, UTBuilt 1978 · S/N AA5A0645 N26687Petro Jerry R · Williamsburg, VABuilt 1940 · S/N 2029 N26688Kirker Edmund J · Omaha, NEBuilt 1978 · S/N AA5A0647 N2668PRegistered aircraftBuilt 1955 · S/N 18-4392 N2668TKing Thomas S · Boerne, TXBuilt 1971 · S/N 28-7205092 N2668WJarchow John H · Denison, TXBuilt 1966 · S/N 993 N26691Stuckenschneider Robert J · Sedona, AZBuilt 1978 · S/N AA5A0648 N26693Truszkowski Donald J · Wyandotte, MIBuilt 1978 · S/N AA5A0649 N26695Drude Kris A · Dayton, OHBuilt 1978 · S/N AA5A0651 N26696Provincetown Pilots Group Inc · Provincetown, MABuilt 1978 · S/N AA5A0652 N2669PLegends LLC · Willow, AKBuilt 1955 · S/N 18-4393 N2669TCity Of Westfield · Westfield, MAS/N 28-7225082 N2669WAlecci Alexander Drew · Sanford, FLBuilt 1966 · S/N 994 N266AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881760 N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104 N266BBetki Randy A · Grosse Ile, MIBuilt 1958 · S/N 126 N266CRag Wings And Radials Aircraft Leasing LLC · Wilmington, DEBuilt 1943 · S/N 6582 N266DLCampbell Thomas J · Center, TXBuilt 2002 · S/N 25154 N266EAero Leasing LLC · Rapid City, SDBuilt 1940 · S/N 2012 N266FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020262 N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157 N266MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881364 N266PJJohnson Philip T · Waxhaw, NCBuilt 1996 · S/N 266 N266SWWeddle Scott M Trustee · Albany, ORBuilt 2003 · S/N 70266 N266WBBell W Douglas · Grand Haven, MIBuilt 2004 · S/N 80889 N266YHogg James R · New Albany, OHBuilt 1968 · S/N 18P N26708Flying Chester Cheetah LLC · Valdosta, GABuilt 1978 · S/N AA5A0665 N26713N26713 LLC · Gainesville, GAS/N AA5A0668 N26715Gulfstream Aerospace Corp · Savannah, GABuilt 1978 · S/N AA5A0670 N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671

Back to AD 90-04-06 R1