Skip to content

Registered aircraft · 1,348

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:73-20-07-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:73-20-07-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:73-20-07-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:73-20-07-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:73-20-07-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:73-20-07-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.

N63732Aeronation Aircraft & Exotics LLC · Lewes, DEBuilt 1982 · S/N M-2365 N63745Johnson Robert L Jr · Cornelius, NCBuilt 1982 · S/N M-2361 N63866Big Bend Community College · Moses Lake, WABuilt 1983 · S/N M-2374 N63MTGriffith Gary L · Palestine, TXBuilt 1962 · S/N M-97 N64840Carter Thomas E · Ocala, FLBuilt 1982 · S/N MC-781 N64ELPridemore Michael R · Newport, MIBuilt 1969 · S/N M-1183 N6501RAbove Earth Aerospace LLC · Friendswood, TXBuilt 1974 · S/N M-1537 N6502RSmith Duane · Felt, OKBuilt 1974 · S/N MC-259 N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716 N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724 N6508RRegistration Pending · Brookings, SDRegistration pendingBuilt 1974 · S/N M-1583 N6509RHolzhauer Aviation Corp · Middletown, DEBuilt 1974 · S/N M-1584 N650VXOneal Timothy James · Vancouver, WABuilt 1967 · S/N MA-194 N6510TLenkersdorfer John D · Burley, IDS/N MB-350 N6511TAgricola Joseph D · Brooksville, FLBuilt 1968 · S/N MB-354 N6513TReilly Michael G · Somerset, NJBuilt 1968 · S/N MB-355 N6514RNess John A · Friday Harbor, WABuilt 1974 · S/N MB-711 N6519RC & C Aeroventures LLC · Carson City, NVBuilt 1974 · S/N M-1542 N6519TVeverka Merle G · Frederick, COBuilt 1968 · S/N MB-356 N6527TBaugher Mark A · Harrison, MIS/N MB-359 N6528NMorgan John A · Katonah, NYBuilt 1982 · S/N M-2366 N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360 N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712 N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713 N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365 N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581 N65503Bentz Andreas · Falls Church, VABuilt 1983 · S/N M2378 N6553RRenkenberger Paul H · Yucaipa, CABuilt 1975 · S/N MB-744 N6558RAntonucci Donald · Barkhamsted, CTBuilt 1974 · S/N MC-294 N6560RBurgett William J · Juneau, AKBuilt 1974 · S/N MB-722 N6562RChavis Martin R · Laurel Hill, NCBuilt 1974 · S/N M-1614 N6564RKuertz Enterprise Ltd · Wilmington, DEBuilt 1974 · S/N MC-301 N6565RAldarondo Luis A · Corvallis, ORBuilt 1974 · S/N MC-302 N6569RMartin Brewster D · Saint Clairsville, OHBuilt 1974 · S/N MC-299 N6569TGarretson Mark W · Victoria, TXBuilt 1968 · S/N M-1144 N6570LHack Mark K · Chatsworth, GABuilt 1983 · S/N M-2379 N6570RBellas Business LLC · Kalispell, MTBuilt 1974 · S/N MC-298 N6578RGrinnell Herbert W · Oroville, CABuilt 1974 · S/N MB-729 N6581RMyrtle Beach Dustless Blasting Llp · Loris, SCBuilt 1975 · S/N MC-303 N6582RFca Flight Training And Aircraft Maintenance Inc · Wshngtn Ct Hs, OHBuilt 1974 · S/N MC-304 N6584TCaufman Richard D · Corry, PAS/N MB-369 N6588RAugust Aero LLC · Kalispell, MTBuilt 1974 · S/N MC-251 N6589RBradley Mark S · Holly, MIBuilt 1975 · S/N MB-731 N6590AJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1983 · S/N M-2380 N6591AHerk Aviation LLC · New Bern, NCBuilt 1983 · S/N M-2381 N6592RSchmidt Louis J · Orange, CABuilt 1974 · S/N MC-308 N6593RZwicker Brian · Richmond Hill, GABuilt 1974 · S/N M-1602 N6594RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-718 N6595RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-714 N6602RFagundes Farms · Hanford, CABuilt 1974 · S/N MB-734

Back to AD 73-20-07 R2