Skip to content

Registered aircraft · 40,395

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N3604KQureini Khalil H · Strongsville, OHBuilt 1967 · S/N 28-23652 N3604PRegistration Pending · League City, TXRegistration pendingBuilt 1955 · S/N 22-3327 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609 N3606EMiller Robert J · Casselton, NDBuilt 1978 · S/N 17271604 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N3606ZLandreth Homer W · Peoria, AZBuilt 1960 · S/N 22-7494 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3607EPalm Cedric C · St Francisville, LABuilt 1978 · S/N 17271605 N3607XAldrich Roy · Webster, SDS/N 5081 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N3608ZBingman William A · Depoe Bay, ORBuilt 1960 · S/N 22-7496 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N3609EBismarck Aero Center Corp · Bismarck, NDBuilt 1978 · S/N 17271606 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N3609ZVeal Petra L · Sterling, AKBuilt 1960 · S/N 22-7497 N360AJAngle Of Attack LLC · Waynesville, OHS/N 25089 N360BHRybczynski Douglas R · Chandler, AZBuilt 1995 · S/N 001 N360BSChampagne Patrick D · San Angelo, TXBuilt 1959 · S/N 18-6869 N360DPSiebert Mcmahon LLC · Kalispell, MTBuilt 1994 · S/N 20084 N360EMAg Flyers Inc · Torrington, WYBuilt 1994 · S/N 20916 N360GJYoung Matthew · Conroe, TXBuilt 1995 · S/N 21735 N360HCMountain Air Spray Co Inc · Craig, COBuilt 1952 · S/N 18-1868 N360JH360jh LLC · Pompton Plains, NJBuilt 1992 · S/N 580 N360KSSavier Helmut Klaus · Santa Paula, CABuilt 2010 · S/N SEZ-1 N360MFBecker James C Trustee · Whitefish Bay, WIBuilt 2003 · S/N 0036 N360MHAcme Racing LLC · Overland Park, KSBuilt 1993 · S/N L-32979-36A N360MLCox Allen W Jr · Clarkton, NCBuilt 1997 · S/N 001 N360RGJay Services LLC · Stephenville, TXS/N 382 N360SRRegistration Pending · Pleasant Grove, CARegistration pending, pending cancellationBuilt 1994 · S/N 20997 N360XPBaker Laurence Todd · Imlay City, MIBuilt 1990 · S/N 566 N3610HScheffing Glenn J · Palm Beach Gardens, FLBuilt 1977 · S/N 20-1246 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N3611HTavalaro Joseph DBA · Massapequa, NYBuilt 1977 · S/N 20-1247 N3611NDowden Frank D · Fallbrook, CABuilt 1967 · S/N 680010 N3612PGoundry George D · Sammamish, WABuilt 1955 · S/N 22-3338 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36137Big Bend Community College · Moses Lake, WABuilt 1973 · S/N 542-73 N3613NBradbury Kevin Earl · Saint George, UTBuilt 1967 · S/N 680011 N3613PLittle Bear Air LLC · Lubbock, TXS/N 22-3339 N36141Averill Terry B · Litchfield, MEBuilt 1973 · S/N 544-73 N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252 N3614RKrautschun Bart · Spearfish, SDS/N 28-5710 N3614XPanther Enterprises LLC · Fort Myers, FLS/N 5090 N3615MRenfro Michael W · Bethel, AKBuilt 1947 · S/N 12-2461 N3615NWalker Eric L · Southlake, TXBuilt 1967 · S/N 680012 N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237

Back to AD 79-10-03 R2