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.

N75EAero Techniques Inc · Portage, MIBuilt 1966 · S/N 17255365 N75MLLowe John Howard II · Tifton, GABuilt 1964 · S/N 18255505 N75NSJohnson Dale B · Steele, NDBuilt 1968 · S/N 17257539 N75SFKlein Neal S · Newberg, ORBuilt 1969 · S/N 18259658 N75SMSummit Aviation Adventures LLC · Fairplay, COBuilt 1963 · S/N 18254675 N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665 N7600VRegistration Pending · Phillipsburg, KSRegistration pendingBuilt 1976 · S/N 177RG0886 N7601GWright Carl E · Conesville, OHS/N 17259301 N7602GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259302 N7603GFelstead R Keith Trustee · Medina, NYBuilt 1970 · S/N 17259303 N7607GOwens Wilbur · Rch Palos Vrd, CAS/N 17259307 N7610GFalconer Robert H · Yolo, CABuilt 1970 · S/N 17259310 N7611GStaunton Curtis J · Tulelake, CABuilt 1970 · S/N 17259311 N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312 N7614VTucker Aviation LLC · Kalispell, MTBuilt 1976 · S/N 177RG0891 N7615GWashington Samuel C · Washington, DCS/N 17259315 N76177Brown Emily D · Niceville, FLBuilt 1975 · S/N 177RG0817 N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319 N761MAWilliams Charlie · Trenton, SCS/N 15065219 N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320 N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321 N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322 N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323 N7623VGove Richard · Riverside, CAFirst renewal noticeBuilt 1976 · S/N 177RG0892 N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324 N7629GDodd Dennis R · Collinsville, OKBuilt 1970 · S/N 17259329 N762MAGiovannetti Peter C · Fond Du Lac, WIBuilt 1966 · S/N 15065187 N7631GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259331 N7636GDurham Ranches Inc · Gillette, WYBuilt 1970 · S/N 17259336 N7637GEverett Flying Service Inc · Holly Grove, ARBuilt 1970 · S/N 17259337 N7637VRamsey Brian S · Monument, COBuilt 1976 · S/N 177RG0898 N7638GMoseley Michael S · Chelsea, ALBuilt 1970 · S/N 17259338 N763PAComputer Services Inc · Yukon, OKBuilt 1974 · S/N 15075618 N763RDDrennan Ronald W · Edmond, OKBuilt 1969 · S/N 18259979 N763TCN42 Hy LLC · Kalispell, MTBuilt 1966 · S/N T210-0113 N7640GCreative Strategies Inc · Proctorville, OHBuilt 1970 · S/N 17259340 N7642GAir Petunia · Claremont, CABuilt 1970 · S/N 17259342 N7643GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259343 N7644GSkypark Inc · Wadsworth, OHBuilt 1970 · S/N 17259344 N7645VBig Sky Aviation Leasing LLC · Helena, MTBuilt 1976 · S/N 177RG0899 N7646GSky Aviation LLC · Encinitas, CABuilt 1970 · S/N 17259346 N7647GIowa Lakes Community College · Estherville, IAS/N 17259347 N7649GSipes Aircraft LLC · Livingston, TXS/N 15074710 N764CPApmg Aircraft Management LLC · Las Vegas, NVBuilt 1965 · S/N 15061758 N7657GDodd Brian G · Mount Vernon, SDBuilt 1973 · S/N 15074711 N765MJBusch Renard · Castro Valley, CABuilt 1967 · S/N 18258116 N7660GKorn Clifton A · Hayward, WIBuilt 1970 · S/N 17259360 N7662GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259362 N7666GHudson Daryl J · Redwood Valley, CABuilt 1970 · S/N 17259366 N7667GBrooks Alan G · Kernersville, NCBuilt 1970 · S/N 17259367

Back to AD 72-03-03 R3