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.

N74644Ice Kevin F · Rock Hill, SCBuilt 1976 · S/N AA5B-0316 N74645Cain Paul · Prunedale, CABuilt 1976 · S/N AA5B-0317 N74646Santa Barbara Flying Club · Goleta, CABuilt 1976 · S/N AA5B-0318 N74647Nelson Brett W · Louisville, KYBuilt 1976 · S/N AA5B-0319 N74648Gasowski James A · Apollo, PABuilt 1976 · S/N AA5B-0320 N74649West End Flyers Inc · San Pedro, CABuilt 1976 · S/N AA5B-0322 N74655Yankee Aviation Services Inc · Plymouth, MABuilt 1976 · S/N AA5B-0325 N74657Janak Russell G · Belton, TXBuilt 1976 · S/N AA5B-0326 N74660Lein Bobby D · Winchester, VABuilt 1976 · S/N AA5B-0328 N74662Knot On The Ground LLC · Miami, FLBuilt 1976 · S/N AA5B0329 N74664Pepitone Dave · Santa Fe, NMS/N AA5B0330 N74665Kagan Perry M · San Marcos, CAS/N AA5B0331 N74670Smith Charles A · Natick, MABuilt 1976 · S/N AA5B0334 N74674Ragged Company LLC · Trenton, FLBuilt 1976 · S/N AA5B-0337 N7467BEllis Matthew D · Park City, UTBuilt 1976 · S/N AA5B0336 N74682Tiger Garb LLC · Stanton, MIBuilt 1976 · S/N AA5B-0341 N74684Blue Eagle Aviation LLC · Nazareth, PABuilt 1976 · S/N AA5B0390 N74687Big Q Aviation Corp · Helena, MTBuilt 1976 · S/N AA5B-0345 N74688Pinetree Sports Inc · Burley, IDBuilt 1992 · S/N 10127 N74692Simpson Mark Withers · Fort Mill, SCS/N AA5B0351 N74699Valles Franck · Vista, CABuilt 1976 · S/N AA5B0355 N74712Airey Alan W · Coppell, TXBuilt 1976 · S/N AA5B0356 N74733Maxwell Stephen R · Dodge City, KSBuilt 1976 · S/N AA5B0357 N74740Woodyatt Michael A · Byron, ILBuilt 1976 · S/N AA5B0358 N747AMHylinski Aviation LLC · Oxford, CTS/N AA5B0893 N747SZN747sz LLC · Chapel Hill, NCBuilt 1977 · S/N AA5A0515 N74801Schilling John H · Lancaster, CABuilt 1976 · S/N AA5B0362 N74818Tiger 818 LLC · Bethesda, MDBuilt 1976 · S/N AA5B0364 N74819Brb Flight Services LLC · Laguna Beach, CABuilt 1976 · S/N AA5B0366 N74820King Brian W · Columbia, CTBuilt 1976 · S/N AA5B0368 N74821Meyers Rodger W · Batesville, INBuilt 1976 · S/N AA5B0369 N74824Martinez Richard P · Upland, CABuilt 1976 · S/N AA5B0372 N74827Marquez Naoko Q · Henderson, NVBuilt 1976 · S/N AA5B0373 N74828Slater Clark A · Esmond, NDBuilt 1976 · S/N AA5B0374 N74846Stall Out Ms LLC · Shalimar, FLBuilt 1976 · S/N AA5B0376 N74858Haffner Sean Geoffrey · Willow Spring, NCBuilt 1976 · S/N AA5B0378 N74865Welch William R Jr · Baton Rouge, LABuilt 1976 · S/N AA5B0388 N74867Carr Thomas J · Overland Park, KSBuilt 1976 · S/N AA5B0391 N74869Feekes Allan D · Aurelia, IAS/N AA5B0393 N74870H O S Aviation LLC · Mount Pleasant, SCBuilt 1976 · S/N AA5B-0270 N74875Thomas Martin G · Tucson, AZBuilt 1976 · S/N AA5B-0271 N74877Hopkinson Keith G · Spicewood, TXBuilt 1976 · S/N AA5B-0272 N74878Stiles Steven A Trustee · Pebble Beach, CABuilt 1976 · S/N AA5B-0273 N74881Rockwood Holdings LLC · Valrico, FLBuilt 1976 · S/N AA5B-0274 N74882Huntley David · San Antonio, TXBuilt 1976 · S/N AA5B-0276 N74884Switek Robert E Jr Trustee · San Andreas, CABuilt 1976 · S/N AA5B-0278 N74886Fisher Robert W · Madison, ALBuilt 1976 · S/N AA5B-0280 N749MCWilliams Rodger Gale · Broseley, MOBuilt 1974 · S/N AA5 0626 N74WBJefferies Eric · Weatherford, TXBuilt 1975 · S/N AA5A-0025 N766LBrashears Chris E · Ventura, CAS/N AA5B0644

Back to AD 95-19-15 R1