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.

N8737UMiss Lou Flight LLC · Vidalia, LABuilt 1965 · S/N 17252641 N8739UAndrews Willard R · Windham, MEBuilt 1965 · S/N 17252643 N873EFFlorida Flight Training Center · Venice, FLBuilt 2006 · S/N 172S10163 N873TWN873tw LLC · Hurricane, WVS/N 17273301 N8740BOltrogge Construction Inc · Absarokee, MTBuilt 1957 · S/N 36440 N8741BPhoenix Air Inc · Orland Park, ILBuilt 1957 · S/N 36441 N8741USexton Mathew G · Rockwell City, IABuilt 1965 · S/N 17252645 N8742BTexas Wings LLC · San Antonio, TXBuilt 1957 · S/N 36442 N8742UJennings Jeff L · Kenly, NCS/N 17252646 N8746BHeffron Jacob L · Little Falls, MNBuilt 1957 · S/N 36446 N8748BOstby Larry · Froid, MTBuilt 1957 · S/N 36448 N8749UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 17252653 N874EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12680 N874JSchoenmann James · Jackman, MES/N 17269733 N8750BLawson Winston P · Hillsboro, OHS/N 36450 N8750UHenryetta Airman Inc · Morris, OKBuilt 1965 · S/N 17252654 N8752UFarm Air Corp · Hoxie, ARBuilt 1965 · S/N 17252656 N8753USowash Allan D · Ontario, OHBuilt 1965 · S/N 17252657 N8754BFoster Steven M · Pekin, ILS/N 36454 N8755BBurton Mark L · Lebanon, OHFirst renewal noticeBuilt 1957 · S/N 36455 N8757ULewis County Flying Club · Lewistown, MOBuilt 1965 · S/N 17252661 N8759UKelly Cynthia · Sealy, TXBuilt 1965 · S/N 17252663 N875CDBoca Pilot LLC · Delray Beach, FLS/N 17264899 N8760BManaged Aviation Inc · The Villages, FLBuilt 1957 · S/N 36460 N8761USmith Dustin T · Jasper, GABuilt 1965 · S/N 17252665 N8762UBelli Christopher J · Oregon, OHBuilt 1965 · S/N 17252666 N8763BMellen Roger B · Roseburg, ORBuilt 1957 · S/N 36463 N8768UWright Roland P · Detroit, MIBuilt 1965 · S/N 17252672 N876EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13523 N876MGAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12709 N876WFries Jeffery A · Paw Paw, MIBuilt 1965 · S/N 17253293 N8773URegistration Pending · Scotch Plains, NJRegistration pendingBuilt 1965 · S/N 17252677 N8775BGauger Cody · Edmond, OKBuilt 1957 · S/N 36475 N8777BBurks Danny E · Fordland, MOBuilt 1957 · S/N 36477 N8778BJohnson Timothy L · Berlin, WIBuilt 1958 · S/N 36478 N8779BMeyers Jess H · Las Vegas, NVBuilt 1957 · S/N 36479 N877AAFlx Flyers LLC · Farmington, NYBuilt 2018 · S/N 172S12152 N877TFMattingly Bruce A · Morehead, KYBuilt 1965 · S/N 17252674 N8780BHite Douglas T · Frisco, TXBuilt 1957 · S/N 36480 N8781UHalsey Gene L · Huron, SDBuilt 1965 · S/N 17252685 N8783BRosine Steven D · Troutville, VAS/N 36483 N8784TElizabeth City State University · Elizabeth City, NCBuilt 2019 · S/N 172S12406 N8786USchlosser Bryan Andrew · Sudlersville, MDBuilt 1965 · S/N 17252691 N8787BHedgers Thomas W · Lino Lakes, MNS/N 36487 N8787UMoody Bible Institute Of Chicago · Spokane, WAS/N 17252692 N8788UIzard Ryan S · Nacogdoches, TXS/N 17252693 N8789TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12408 N878EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12684 N878SATampa Bay Aviation Inc · Clearwater, FLBuilt 2006 · S/N 172S10209 N8791BCook Robert G · Rensselaer, NYBuilt 1957 · S/N 36491

Back to AD 90-06-03 R1