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.

N3615SBlacqjacq Aviation Co · Wilmington, DEBuilt 1963 · S/N 17250815 N3616LSoflair Aviation Solutions LLC · Miami, FLS/N 17253785 N3616SArtisan Outreach LLC · Dunnellon, FLBuilt 1964 · S/N 17250816 N3619SFitch Aviation Holdings LLC · Pottsboro, TXBuilt 1963 · S/N 17250819 N361CCSackman Robert B · Unionville, INBuilt 1961 · S/N 17248703 N361CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8840 N361ESGrady Paul D · Reno, NVBuilt 1997 · S/N 17280011 N361GAGlidewell Aviation Inc · Parkland, FLBuilt 2003 · S/N 172S9521 N361LRegistered aircraftBuilt 2004 · S/N 172S9569 N361LULewis University · Romeoville, ILBuilt 2020 · S/N 172S12564 N361RHDerdak Stephen · San Antonio, TXBuilt 1956 · S/N 29013 N361XSorley Steven J · Roy, UTBuilt 1957 · S/N 36238 N3620LMullins Lawrence D · Germantown, OHBuilt 1965 · S/N 17253789 N3620SBoese Howard · Brownell, KSBuilt 1963 · S/N 17250820 N3621SAlletto Alexander J · Russell Springs, KYBuilt 1964 · S/N 17250821 N3622LStrelzik Raymond W · Hatfield, PABuilt 1965 · S/N 17253791 N3622SMichael Lewis R · Big Rapids, MIS/N 17250822 N3625LWilliams Michael R · Gig Harbor, WABuilt 1965 · S/N 17253794 N3626LKoshar Robert E · Watervliet, MIBuilt 1965 · S/N 17253795 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N3627LGeorge Edward J · Highland Village, TXBuilt 1965 · S/N 17253796 N3628LThrasher Gary Phillip · Galena, OHBuilt 1965 · S/N 17253797 N3628SWright Way Air Venture LLC · Westville, INBuilt 1963 · S/N 17250828 N3629SBradley Christopher J · Left Hand, WVBuilt 1963 · S/N 17250829 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280013 N362LULewis University · Romeoville, ILBuilt 2023 · S/N 172S12983 N362QRegistered aircraftBuilt 2018 · S/N 172S12188 N362SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2001 · S/N 172S8779 N3630SFly Dogs LLC · Sunbury, OHBuilt 1963 · S/N 17250830 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3631LMcveigh Ian T · Mansfield, TXS/N 17253800 N3631SJust Plane Fun 9m6 LLC · Lake Providence, LABuilt 1963 · S/N 17250831 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803 N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3636SGriesman Scott W · Sandy Valley, NVBuilt 1963 · S/N 17250836 N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808 N363BLElizabeth City State University · Elizabeth City, NCBuilt 2004 · S/N 172S9741 N363CKAviator Air Operations LLC · Grand Prairie, TXBuilt 2004 · S/N 172S9634 N363CPBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 172S8382 N363KRegistered aircraftBuilt 2018 · S/N 172S12195 N363MAMuchodeanaero Inc · Wilmington, DEBuilt 1998 · S/N 172S8006 N363SAN363sa LLC · Stuart, FLS/N 17280756 N363SPOrange County Flight Center Inc · Santa Ana, CABuilt 2001 · S/N 172S8781 N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809 N3640SPetersen Jacob R · Wasilla, AKS/N 17250840

Back to AD 90-06-03 R1