Skip to content

Registered aircraft · 20,687

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N753SCJuliet Charlie Aviation LLC · Keizer, ORBuilt 2019 · S/N 172S12328 N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240 N7541TSmith Danny R · Sherman, TXBuilt 1959 · S/N 47141 N7541XRegistered aircraftBuilt 1960 · S/N 17248041 N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242 N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243 N7543TBlakeney David B · Pocahontas, ARBuilt 1959 · S/N 47143 N7544XRobert S Williams Dds Ps · Grandview, WABuilt 1960 · S/N 17248044 N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247 N7547THall William D · Homeworth, OHBuilt 1959 · S/N 47147 N7547XArmitage Donald · New Derry, PABuilt 1960 · S/N 17248047 N7548GRetro Modern Aviation LLC · Manitou Springs, COBuilt 1970 · S/N 17259248 N7548TWatkins Frank E · Montague, CABuilt 1959 · S/N 47148 N7548XKruger Daniel G · Stateline, NVBuilt 1960 · S/N 17248048 N7549XNagy Alec S · Cherry Hill, NJBuilt 1960 · S/N 17248049 N754CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11574 N754FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13276 N754SPNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 2001 · S/N 172S8680 N7550G7550g LLC · Birmingham, MIBuilt 1970 · S/N 17259250 N7550TShipe Jacqueline M · Louisville, TNBuilt 1959 · S/N 47150 N75513Baird David J · Mount Shasta, CABuilt 1976 · S/N 17267773 N75515N75515 LLC · Palm City, FLBuilt 1976 · S/N 17267774 N75516Morristown Flying Service Inc · Talbott, TNBuilt 1976 · S/N 17267775 N75518Cloudhop LLC · Pinehurst, TXBuilt 1976 · S/N 17267776 N7551GNb Airdoc LLC · Aventura, FLBuilt 1970 · S/N 17259251 N7551XDraughon Robert W · Forney, TXS/N 17248051 N75522Bradley Alexander L · Chesapeake, OHS/N 17267779 N75529Jmw Skyhawk LLC · Midland Park, NJBuilt 1976 · S/N 17267784 N7552THaycraft James Michael · Magnolia, KYS/N 47152 N75531Garner Michael A · Hernando, MSBuilt 1976 · S/N 17267786 N75532Darrow William A · Guthrie Center, IABuilt 1976 · S/N 17267787 N75535Skyhawk Cowboys LLC · Port Angeles, WABuilt 1976 · S/N 17267790 N75536N75536 LLC · Palm City, FLBuilt 1976 · S/N 17267791 N75537Jimenez Carlos · Davie, FLBuilt 1976 · S/N 17267792 N75538Mike Moser Inc · Wilmington, DEBuilt 1976 · S/N 17267793 N7553EPolley Terri J · San Antonio Height, CAFirst renewal noticeBuilt 1978 · S/N 17272106 N75548Mcfadden Edward C · Ferris, TXBuilt 1976 · S/N 17267798 N75549Matthews Raymond H Jr · Rhoadesville, VABuilt 1976 · S/N 17267799 N75555American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267804 N75559Gillanders Robert Ross Personal Representative · Gig Harbor, WABuilt 1976 · S/N 17267808 N7555GSac Air LLC · Citrus Heights, CABuilt 1970 · S/N 17259255 N75560Nexga Aircraft Inc · Greensboro, NCS/N 17267809 N75565Flight 915 LLC · El Paso, TXS/N 17267814 N75566Wilson Robert J · Annville, PABuilt 1976 · S/N 17267815 N7556GWetlesen Gabriel C · Palmer, AKBuilt 1970 · S/N 17259256 N7556TOleskiewicz Anna · Palm Beach Shores, FLBuilt 1959 · S/N 47156 N75571Kohls Bruce P · Melbourne, KYBuilt 1976 · S/N 17267817 N75572Bean Keith Owen · Glenwood, IABuilt 1976 · S/N 17267818 N75575Mayo William J Jr · Reed Point, MTBuilt 1976 · S/N 17267820 N7557GLe Gros Donald P · Jennings, LABuilt 1970 · S/N 17259257

Back to AD 90-06-03 R1