Skip to content

Registered aircraft · 5,075

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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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:84-19-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.

N3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N T20608322 N3548BJaa Holdings LLC · Springfield, ILBuilt 1979 · S/N 31-8052025 N3548JCarden Kevin · Hoover, ALBuilt 1979 · S/N 31-8052027 N35497Fox Aircraft LLC · Bethel, AKBuilt 1979 · S/N 31-8052039 N3549XAirplane Four LLC · Miami, FLFirst renewal noticeBuilt 1980 · S/N 31-8052034 N3551CT23 Aviation LLC · Hutchinson, MNS/N 31-8012019 N3555KPerman Edward O Jr · Rainbow City, ALFirst renewal noticeBuilt 1980 · S/N 31-8012037 N3556XWest Bend Air Inc · West Bend, WIBuilt 1980 · S/N 31-8012042 N3556ZJohnson Paul A Trustee · Bloomfield Hills, MIBuilt 2001 · S/N T18208060 N35580Aero Charter New England Inc · Mansfield, MABuilt 1980 · S/N 31-8052075 N35584Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1980 · S/N 31-8052076 N3558XAwmr LLC · Conroe, TXBuilt 1980 · S/N 31-8052073 N3559QIndependence Air LLC · Advance, NCBuilt 1979 · S/N 32R-8029022 N355RZKpae Partners LLC · Issaquah, WABuilt 1997 · S/N 27-0235 N355SRMoonglow Aviation LLC · Dover, DEBuilt 2004 · S/N T20608458 N3560GVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N T18208063 N35679Mid Valley Flying LLC · Progreso, TXBuilt 1979 · S/N 32R-8029030 N356DBCaldwell Island LLC · Sherborn, MABuilt 1978 · S/N 31-7852056 N356MEGlass Cockpit Aviation-Sunvalley LLC · Hailey, IDBuilt 2000 · S/N 18280844 N356SFSheehan Aviation Family Enterprises LLC · Boise, IDS/N T20608496 N3576XField Aviation LLC · Fairview, TXBuilt 1979 · S/N 32R-8029035 N3577DAga Aviation LLC · Lewes, DEBuilt 1979 · S/N 32R-8029036 N3579QSchwartz Douglas · Plymouth, MIBuilt 1979 · S/N 32R-8029039 N357SAFox Aircraft LLC · Wasilla, AKBuilt 1980 · S/N 31-8052162 N35834Carto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052115 N35841Flyingvine LLC · Gilford, NHBuilt 1980 · S/N 31-8012054 N3586DDurrell Lee W · Memphis, TNBuilt 1980 · S/N 31-8012065 N3586XPops Aviation Inc · Spartanburg, SCBuilt 1980 · S/N 31-8012070 N3587PMsm587p LLC · Jericho, NYS/N 31-8052120 N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139 N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134 N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138 N358ELCub Crafters Inc · Yakima, WABuilt 1996 · S/N E1 N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143 N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144 N35GGWilforge LLC · Phoenix, AZBuilt 1999 · S/N 4636207 N35RDIngersoll Grove LLC · Springfield, MABuilt 1977 · S/N 31-7852039 N36073M C Aviation Holding Co LLC · Bryan, TXBuilt 1978 · S/N 32R-7887021 N3609QNorthern Aviation LLC · Palmer, AKBuilt 1977 · S/N 32R-7780319 N3611BRestorations & Rentals LLC · Tulsa, OKBuilt 1970 · S/N 27-4579 N361RPRocha Aviation LLC · Prescott Valley, AZBuilt 1973 · S/N 32-7440046 N361WA32 Poco LLC · Dover, DEBuilt 1999 · S/N 3257121 N36201Bmw Lance Inc · Gardner, MABuilt 1978 · S/N 32R-7887027 N36202Red Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1978 · S/N 32R-7887028 N362ABReynolds Bruce G · Wausau, WIBuilt 1980 · S/N 32R-8029068 N362BMAmerican Valet Air Inc · Wilmington, DEBuilt 1973 · S/N 27-7305171 N362DMRegions Aloft LLC · Brooksville, FLBuilt 2004 · S/N 3257362 N3635S2nd Chance Enterprise LLC · North Haledon, NJBuilt 2002 · S/N T18208179 N36390Robertson Kevin E · Austin, TXBuilt 1978 · S/N 32R-7887039 N363MMChicola Monty · Alexandria, LAS/N 4622007

Back to AD 84-19-03 R1