Skip to content

Registered aircraft · 40,471

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N84054Far Horizons LLC · Ravenel, SCBuilt 1981 · S/N 28-8116257 N8405BMiloud Chadd K · Fort Worth, TXBuilt 1981 · S/N 28-8116252 N8405RShields Parker · Port Orange, FLBuilt 1966 · S/N 28-22345 N8405SAlston Tony · Midland, TXBuilt 1981 · S/N 28-8116255 N8405WTaylor Dale E · Kimball, SDBuilt 1965 · S/N 28-2621 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406AColorado High Flyers LLC · Colorado Springs, COBuilt 1981 · S/N 28-8290017 N8406HP A Flying LLC · Pueblo, COFirst renewal noticeBuilt 1981 · S/N 28-8190269 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8406WWright Jordan M · York, SCBuilt 1965 · S/N 28-2623 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407DRegistration Pending · Manassa, CORegistration pendingBuilt 1957 · S/N 22-5660 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107 N8407PMark Gary Flying Service Inc · Inverness, MSBuilt 1965 · S/N 18-8295 N8407WIsland Flyers LLC · Apopka, FLBuilt 1983 · S/N 58 N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326 N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327 N8408BCharlton Gary R II · Loudonville, NYBuilt 1981 · S/N 28-8116258 N8408CDallas Secure Storage LLC · Dallas, ORBuilt 1976 · S/N 28-7625113 N8408DAeromarine Consulting Inc · Brandon, FLS/N 22-5661 N8408ECandace A Larned Enterprises Inc · Long Beach, CABuilt 1981 · S/N 28-8116259 N8408LMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28-8116261 N8408RWilliams Christopher A · Kent, WAS/N 28-22285 N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328 N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329 N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331 N8409DWinters David W · Gustine, TXBuilt 1957 · S/N 22-5662 N8409LRegistered aircraftBuilt 1968 · S/N 17256609 N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665 N8409RRatliff Christopher · Manteno, ILBuilt 1966 · S/N 28-22286 N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334 N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337 N84109Bielak Donald · Louisburg, KSBuilt 1981 · S/N 28-8290034 N8410CLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7615105 N8410ETito Hector · Fayetteville, GABuilt 1979 · S/N 17272196 N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610 N8410SNorth Shelby Aviation LLC · Wilmington, DEBuilt 1981 · S/N 28-8116263 N8410WRenegade6 Aviation LLC · Woodbridge, VABuilt 1965 · S/N 28-2629 N84114Miami Seaplane Tours Inc · Miami, FLBuilt 1969 · S/N 17258339 N84117Mendez Arturo · Addison, ILBuilt 1969 · S/N 17258340 N8411BGrohs Dihl J · Wessington Springs, SDBuilt 1981 · S/N 28-8190275 N8411CRtb Aviation LLC · Jurupa Valley, CABuilt 1976 · S/N 28-7690136 N8411DElliott Frank F · Mojave, CABuilt 1957 · S/N 22-5664 N8411REleven Romeo LLC · Golden, COBuilt 1966 · S/N 28-22288 N8411WHiggins Timothy Owen · Axtell, TXS/N 28-2635 N84122Millican Marc J · Anchorage, AKBuilt 1969 · S/N 17258342

Back to AD 80-04-03 R2