Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N6976FCalder Mark A · Midlothian, TXBuilt 1966 · S/N 15063576 N6976SMancine Timothy J · Turner, MEBuilt 1967 · S/N 15067676 N6977FRice Dennis L · Crawfordsville, INBuilt 1966 · S/N 15063577 N6978Jackson Kent S · Washington, DCBuilt 1974 · S/N 11221 N6978AMcbride Robert W · Mineola, TXBuilt 1956 · S/N 29078 N6978ECrotts Jon A · Garden City, KSS/N 56478 N6978GSaia Mark · Oak Harbor, WAS/N 15072478 N6979AButcher William J · Salem, OHS/N 17229079 N6979GWestall Ken L · Santa Maria, CABuilt 1970 · S/N 15072479 N6979XScott Thomas A Jr · Lawrenceburg, TNBuilt 1960 · S/N 17247879 N6980DJohnson Tracy L · Magnolia, TXS/N 18-5508 N6980FEnvii Aviation LLC · Monroe, WAS/N 15063580 N6980GSamudio Lazaro III · Wildomar, CABuilt 1970 · S/N 15072480 N6980HMoss Jimmy D Jr · Tillar, ARBuilt 1946 · S/N 20225 N6980XMartin Timothy L · Cecilia, KYBuilt 1960 · S/N 17247880 N6981SSalerno Gina · Cape Coral, FLBuilt 1967 · S/N 15067681 N6981XBoswell Steven P · Clear Spring, MDBuilt 1960 · S/N 17247881 N6982GBedford Cutter G · Bremerton, WAS/N 15072482 N6983GGoemmel Steven J · Airway Heights, WABuilt 1971 · S/N 15072483 N6983XOptivol Corp · Miami, FLBuilt 1960 · S/N 17247883 N6984DDerickson James L · Ukiah, CABuilt 2010 · S/N 75-7889 N6984GCoffel Alexander · Meridian, IDS/N 15072484 N6984XFive Delta Sierra Inc · Pembroke Pines, FLBuilt 1960 · S/N 17247884 N6985AImwalle John N · Batavia, OHBuilt 1956 · S/N 29085 N6985EThomas Steven J · Wasilla, AKBuilt 1960 · S/N 56485 N6985GBustamante Wilton F · Whitsett, NCBuilt 1971 · S/N 15072485 N6985XNazario Juan A · Orlando, FLBuilt 1960 · S/N 17247885 N6986APoindexter Charles A Sr · West Point, MSBuilt 1956 · S/N 29086 N6986SKass Deborah J · Chandler, AZBuilt 1967 · S/N 15067686 N6986XMcallister Paul · Delafield, WIBuilt 1960 · S/N 17247886 N6987FGacesa Samuel M · Belton, TXBuilt 1966 · S/N 15063587 N6987HBattey Edward L · Greene, RIBuilt 1942 · S/N 20232 N6987SHubbard Broadcasting Inc · Saint Paul, MNBuilt 1967 · S/N 15067687 N6988ARegistered aircraftBuilt 1956 · S/N 29088 N6988EPeterson Andrew B · Louisville, KYS/N 56488 N6988FPaulson Allerton · Anoka, MNBuilt 1966 · S/N 15063588 N6988XPaul Aviation LLC · Wasco, CAS/N 17247888 N6990EGray Jade · Odessa, TXS/N 56490 N6990FWohlers Paul A · Calimesa, CABuilt 1966 · S/N 15063590 N6990RFord Kevin A · League City, TXBuilt 2009 · S/N CC11-00108 N6991EHiggins Frank E · Rio, WIBuilt 1960 · S/N 56491 N6991FMeyer George D · Paradise, CAS/N 15063591 N6991GMid South Aircraft Sales Inc · Glencoe, ALBuilt 1971 · S/N 15072491 N6992FJenkins Seth A · Charlotte, NCBuilt 1966 · S/N 15063592 N6992GMosch Edward C · Indialantic, FLBuilt 1971 · S/N 15072492 N6992XBurleson James R · Snyder, TXBuilt 1960 · S/N 17247892 N6993AHurta Jennifer · Cypress, TXBuilt 1956 · S/N 29093 N6993ENewberry Wilma L · West Paducah, KYBuilt 1960 · S/N 56493 N6993FBordens Jacob R · Chatham, NJBuilt 1966 · S/N 15063593 N6994AMeador George D · Austin, TXBuilt 1956 · S/N 29094

Back to AD 94-05-05 R1