Skip to content

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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.

N67TDBrockton Flying Club Inc · Taunton, MABuilt 1990 · S/N 10005 N67TPJohnson Douglas A · Trenton, SCBuilt 1974 · S/N AA5-0672 N6812TChambless Frank M · Cedar Bluff, ALBuilt 1972 · S/N AA5-0127 N681FSMcmurtry Steven · El Dorado Hills, CABuilt 1990 · S/N AA5B0400 N6841LSaglimbene Ronald · Wyckoff, NJBuilt 1978 · S/N AA5A0621 N68BAllen April E · Green Cove Springs, FLBuilt 1976 · S/N AA5A-0182 N68JCCapps Jon T · Bentonville, ARBuilt 1975 · S/N AA5-0801 N68RLSlutz David E · Morristown, TNBuilt 1979 · S/N AA5A0865 N698CPSerodind Peterj · Chattanooga, TNBuilt 1978 · S/N AA5B0915 N6DGTimperman Eugene L · Cincinnati, OHBuilt 1979 · S/N AA5B1162 N6SYKirkpatrick Andrew T · Corpus Christi, TXBuilt 1975 · S/N AA5B-0210 N701THSmoke Seen LLC · Farmingdale, NYBuilt 1978 · S/N AA5B1037 N70549Andersen Mark · Huntley, ILBuilt 1993 · S/N 10152 N707JGRegistration Pending · North Andover, MARegistration pendingBuilt 1977 · S/N AA5B0607 N70GDBig Bend Soaring Inc · Port Orange, FLBuilt 1976 · S/N AA5B-0338 N70PWStoner Tommy E · Kennesaw, GABuilt 1976 · S/N AA5B-0265 N7102LWestergard Matthew J · Fort Mill, SCBuilt 1973 · S/N AA5-0402 N7105LTolbert John M · Jacksonville Beach, FLBuilt 1973 · S/N AA5-0405 N7107LYellowjet Flying Club LLC · Mukilteo, WAS/N AA5-0637 N7108LWeiland Scott J · Howe, INBuilt 1973 · S/N AA5-0408 N7109LSimpson Brian · Indian Trail, NCS/N AA5-0409 N7112LDoskicz Harry N · Slatington, PAS/N AA5-0612 N7113LBlanton Ronald · Lascassas, TNBuilt 1974 · S/N AA5-0675 N711APStrzelski Edward · Perkasie, PABuilt 1979 · S/N AA5B1314 N7120LTschirhart Larry S · San Antonio, TXBuilt 1974 · S/N AA5-0620 N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624 N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425 N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428 N7131LMalof Matthew P · Falls Church, VABuilt 1974 · S/N AA5-0631 N7133LHutchins Perry L · Little Rock, ARS/N AA5-0433 N7134LCook'S Aviation LLC · Conover, NCBuilt 1973 · S/N AA5-0434 N7136LSchulte Barry M · Union, NJBuilt 1973 · S/N AA5-0436 N7137LSlinkard Andrew L · Mesa, WAS/N AA5-0437 N7140LK Anthony Lax Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N AA5-0640 N7141LWamar Enterprises LLC · Eureka, MOBuilt 1974 · S/N AA5-0641 N7142LEshuis Hermannus A · Lake City, FLS/N AA5-0442 N7144LN7144l LLC · Sealy, TXBuilt 1973 · S/N AA5-0444 N7147LFletchair Inc · Comfort, TXBuilt 1973 · S/N AA5-0447 N7149LBell Larry B · Albuquerque, NMBuilt 1973 · S/N AA5-0449 N7150LHouston Lewis · Albuquerque, NMBuilt 1973 · S/N AA5-0450 N7152LGaither David G Executor · Houston, TXBuilt 1973 · S/N AA5-0452 N7155LWright David M · Winchester, CABuilt 1973 · S/N AA5-0455 N7156LExcalibur Aviation LLC · Amelia Court House, VABuilt 1973 · S/N AA5-0456 N7157LZuwerink Michael J · Holton, MIBuilt 1973 · S/N AA5-0457 N7158LSears Wes L · Tacoma, WABuilt 1973 · S/N AA5-0458 N7159LRowlett Roger S · Hamilton, NYBuilt 1973 · S/N AA5-0459 N7160LHuntley Michael E · Sonora, CAS/N AA5-0460 N7163LKandybowski Steven J · Tower City, PABuilt 1973 · S/N AA5-0463 N7164LOverby Ronald L · Eau Claire, WIBuilt 1973 · S/N AA5-0464 N7168LAltaii Ali A · Gibraltar, MIS/N AA5-0468

Back to AD 95-19-15 R1