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.

N6556SPflederer Raymond F · Sturgeon Bay, WIBuilt 1967 · S/N 15067356 N6558FMolek Jon · Warren, OHS/N 15063158 N6558SVan Bavel Ethan G · Soldotna, AKBuilt 1967 · S/N 15067358 N6559SReichelt Harvey R · Ossian, INBuilt 1967 · S/N 15067359 N6560SClemons Mark T · Bullhead City, AZBuilt 1967 · S/N 15067360 N6561FWings Aero LLC · Zeeland, MIBuilt 1966 · S/N 15063161 N6561GDave Faust Inc · Wellington, KSBuilt 1970 · S/N 15072061 N6563GVito Air Inc · Wilmington, DES/N 15072063 N6563SPendley Terry · Carbon Hill, ALBuilt 1967 · S/N 15067363 N6564FBradley John · Edgewood, NMBuilt 1966 · S/N 15063164 N6565GRoberts Brian L · Shelbyville, INBuilt 1970 · S/N 15072065 N6566FOdekirk David C · Watertown, WIBuilt 1966 · S/N 15063166 N6566GHopkins Juan A · Nogales, AZBuilt 1970 · S/N 15072066 N6568GAntler Aviation And Wildlife Service LLC · Wasilla, AKS/N 15072068 N6568SBell Daniel M · Mc Alpin, FLFirst renewal noticeBuilt 1967 · S/N 15067368 N6569FWise Joe · Kilgore, TXBuilt 1966 · S/N 15063169 N6569SSawicki Victor · Columbus, MIBuilt 1967 · S/N 15067369 N6570FMykland Bennett · Graham, WABuilt 1966 · S/N 15063170 N6570SAnderson Christopher D · Newark, OHBuilt 1967 · S/N 15067370 N6572GAero Equities LLC · Ventura, CABuilt 1970 · S/N 15072072 N6572SGlatt Nicolas · Mazama, WABuilt 1967 · S/N 15067372 N6575FBarnett Joe N · Siloam Springs, ARBuilt 1966 · S/N 15063175 N6579FPratka Rhett A · Pleasanton, TXBuilt 1966 · S/N 15063179 N657SCKruse Shannon E · Republic, MOBuilt 1973 · S/N 177RG0301 N657SRRm & Lp Ltd · Azalea, ORBuilt 1968 · S/N 17701019 N6580FLawson Jeremiah · Lunenburg, VTBuilt 1966 · S/N 15063180 N6580GMonskey David Paul · Minnetonka, MNBuilt 1970 · S/N 15072080 N6581GCox Martin S · Greenwood, INBuilt 1970 · S/N 15072081 N6582FHemmatyar Nabi Z · Malibu, CAS/N 15063182 N6583FButterfield Rory A · Milan, NMS/N 15063183 N6583GRusch Steven A · Sequim, WABuilt 1970 · S/N 15072083 N6585FBrouse Dan T · Magnolia, TXBuilt 1966 · S/N 15063185 N6585GPace Glen M · Columbia, MSBuilt 1970 · S/N 15072085 N6586FLunar Aviation LLC · Tahlequah, OKBuilt 1966 · S/N 15063186 N6586SMiller William H · Live Oak, FLS/N 15067386 N6587FJones Aviation Inc · Biggs, CABuilt 1966 · S/N 15063187 N6587GGilkes Simon J · Gilbert, AZBuilt 1970 · S/N 15072087 N6588GAstro Aviation Inc · Whitney Point, NYBuilt 1970 · S/N 15072088 N6589FRush Paul E · Highland, KSS/N 15063189 N6589SAdamson Paul B · Sparks, NVS/N 15067389 N658SRJung Sue Elaine · Lawton, OKBuilt 1968 · S/N 17700976 N6590FMapes Peter B · Oscoda, MIBuilt 1966 · S/N 15063190 N6590SCoonley Russell F · Decatur, TXBuilt 1967 · S/N 15067390 N6592SBasista Robert J · Delaware, OHS/N 15067392 N6593SMilam David N · Hannibal, MOBuilt 1967 · S/N 15067393 N6594GKabat Orville · Rudyard, MIBuilt 1970 · S/N 15072094 N6595FRose Edward · Brooklyn, NYBuilt 1966 · S/N 15063195 N6595SGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1967 · S/N 15067395 N6596FTrenholm Daniel L · Eagan, MNBuilt 1966 · S/N 15063196 N65978Freeland Christopher G · Brownwood, TXS/N 15075753

Back to AD 72-03-03 R3