Skip to content

Registered aircraft · 20,683

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.

N63663Lake Aviation LLC · Murfreesboro, TNBuilt 1981 · S/N 17275465 N6366FDerose Joseph F · Salt Springs, FLBuilt 1979 · S/N 17273204 N63681American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275467 N63694Upper Valley Aero LLC · Hanover, NHBuilt 1981 · S/N 17275470 N6369ETeed Brad S · Vancouver, WABuilt 1959 · S/N 46469 N636CBN636cb LLC · Bensenville, ILBuilt 2019 · S/N 172S12261 N636CMCaelum Et Terra LLC Series B · Evanston, ILBuilt 2021 · S/N 172S12657 N636CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11462 N636CXNewton Property Leasing LLC · Greene, IABuilt 1978 · S/N 17271789 N636EMAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12852 N636LSN636ls LLC · Bensenville, ILBuilt 2020 · S/N 172S12474 N636SAMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9636 N63702Smith Brian E Trustee · Richland, WABuilt 1981 · S/N 17275471 N6370DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272756 N63715Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275473 N63716Michael Thomas O Trustee · Oldsmar, FLBuilt 1981 · S/N 17275474 N63718Putnam Donald P · Orla, TXBuilt 1981 · S/N 17275475 N6371EPrincy Lala · Deltona, FLS/N 46471 N6372DHofmann LLC · Blauvelt, NYBuilt 1979 · S/N 17272758 N6374DWings Flight Enterprises Inc · Danville, KYBuilt 1979 · S/N 17272760 N6375DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272761 N6375EDial Eric A · Eldon, MOBuilt 1959 · S/N 46475 N63767Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275480 N6376EZawacki William M · Medford, WIBuilt 1959 · S/N 46476 N63772Petty Charles R Trustee · Hamilton, MTBuilt 1981 · S/N 17275481 N6379FHuffman Jacob M III · Burleson, TXS/N 17273211 N637CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11463 N6380DLawson Justin · Jeffersonville, KYS/N 17272766 N6380ECessna N6380e LLC · Spring Branch, TXBuilt 1978 · S/N 17272011 N6382DSocal Aviation Inc · Eastvale, CAS/N 17272768 N6383FWilliams William C Jr · Houston, TXFirst renewal noticeBuilt 1979 · S/N 17273213 N63843Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275490 N6384DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272770 N63852Richmor Aviation Inc · Scotia, NYBuilt 1981 · S/N 17275491 N6385ELucky Dog Land Co LLC · Caldwell, IDBuilt 1959 · S/N 46485 N6386ER M Aviation Inc · Lakeview, MIBuilt 1979 · S/N 17272013 N6386VSaunders Andreas · Wake Forest, NCS/N 172RG0649 N6387FMitich Nathan · Fort Worth, TXBuilt 1980 · S/N 17273214 N6388DBdo Aviation LLC · Dallas, TXBuilt 1979 · S/N 17272774 N638AGSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11464 N638CTCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10781 N6390ERyan Michael P · Melrose, IAFirst renewal noticeBuilt 1959 · S/N 46490 N63918Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275495 N6391EDay Stephen F · Queen Creek, AZBuilt 1959 · S/N 46491 N6391JAty Aviation Inc · Watertown, SDBuilt 1980 · S/N 17273868 N6392GJtw Aero Leasing LLC · Frederick, MDBuilt 1979 · S/N 17273592 N6392YBoldflight LLC · Greenwood, INBuilt 1975 · S/N 17264795 N6393EBrewster Richard D · Bellvue, COBuilt 1959 · S/N 46493 N6393GKrusell Robert S · Blairsville, GABuilt 1979 · S/N 17273593 N6393RGilbert John · Austin, TXBuilt 1979 · S/N 172RG0176

Back to AD 90-06-03 R1