Skip to content

Registered aircraft · 17,027

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

N7075FGillette Timothy R · Ipswich, MABuilt 1966 · S/N 15063675 N7075GDraper Floyd L · El Paso, TXBuilt 1969 · S/N 17258775 N7075QCorell Ryan J · Mason City, IAS/N 17260375 N7076QAbbott Brett C · Leawood, KSBuilt 1972 · S/N 17260376 N7076SHaeg Timothy R · Saint Joseph, MNBuilt 1967 · S/N 15067776 N70778Engleman Aviation LLC · Comfort, TXBuilt 1968 · S/N 18259366 N707BSConboy Enterprises LLC · Lexington, KYS/N 18253773 N707CGMohler Mark R · Green Cove Springs, FLBuilt 1977 · S/N 177RG1310 N707DRRichardson Douglas · Goodlettsville, TNBuilt 1970 · S/N 17701458 N707JYBest Glide LLC · Davie, FLS/N 17253465 N707KVieques Aero Club LLC · Ouray, COBuilt 1963 · S/N 205-0439 N707MTams LLC · North Las Vegas, NVS/N 15065924 N707XJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 17701340 N70800Gangloff William A Jr · Frederick, MDS/N 18259367 N70802Brandvik Pipe & Equipment Inc · Borger, TXBuilt 1968 · S/N 18259369 N70804Fanning Fred W · Fairlawn, OHBuilt 1968 · S/N 18259370 N70809Inman Steve J · Billings, MTBuilt 1968 · S/N 18259373 N7080QFerraro Paul · Seattle, WABuilt 1972 · S/N 17260380 N70816Proctor Keith · Paint Lick, KYS/N 18259378 N7081FHayes Travis · Harrisonville, MOBuilt 1966 · S/N 15063681 N7081SGustafson Clayton H · Woodbury, CTS/N 15067781 N70826Chabay Shawna P · Greenleaf, IDBuilt 1968 · S/N 18259380 N7082FBuchanan Walter C · Yuma, AZBuilt 1966 · S/N 15063682 N7082GBbt Inc · Wilmington, DEBuilt 1969 · S/N 17258782 N7082QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260382 N7083GMassie Robert G · Whitewater, WIBuilt 1969 · S/N 17258783 N7083QSevensixzerozero LLC · Boerne, TXBuilt 1972 · S/N 17260383 N70845Registered aircraftBuilt 1968 · S/N 18259390 N70849Hedrick Chad A · Goshen, OHS/N 18259393 N7084QMarcks Jason M · Shiocton, WIFirst renewal noticeS/N 17260384 N7084SGreer John M Jr · Mercer Island, WABuilt 1967 · S/N 15067784 N7085GRegistered aircraftBuilt 1969 · S/N 17258785 N7085SMatthews Suzanne M · Horseheads, NYS/N 15067785 N70861Importico William J · Bridgewater, NJBuilt 1968 · S/N 18259397 N70867Phantom Flyer LLC · Yelm, WABuilt 1968 · S/N 18259400 N7086FCooley Dennis Andrew · Wasilla, AKBuilt 1966 · S/N 15063686 N7086GSniffen Wesley H · Sycamore, OHBuilt 1969 · S/N 17258786 N70872Johorn LLC · Downingtown, PABuilt 1968 · S/N 18259402 N7087FParnell Don E · Alexandria, LAS/N 15063687 N7087GRavindran Manoj · Clarksville, TNBuilt 1970 · S/N 17258787 N70884Walbert Frank J · Pagosa Springs, COBuilt 1969 · S/N 18259405 N70885Bates Ranches · Condon, ORBuilt 1968 · S/N 18259406 N70888Nbw Wings LLC · Cave Creek, AZBuilt 1968 · S/N 18259408 N7088FVander Mey Thomas H · Aitkin, MNBuilt 1966 · S/N 15063688 N7088GSardeis LLC · River Hills, WIS/N 17258788 N70892Williams Tyler D · Tracy, CABuilt 1968 · S/N 18259410 N708CCOlivier Seth N · Baskin, LABuilt 1966 · S/N 15063262 N70901Ckt Aviation LLC · Anchorage, AKBuilt 1968 · S/N 18259411 N70902Bienz David E · Scottsdale, AZBuilt 1968 · S/N 18259412 N70913Sunset Aviation LLC · New Iberia, LABuilt 1968 · S/N 18259416

Back to AD 72-03-03 R3