Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868 N2869LHelmstetler John D · Mt Vernon, TXBuilt 1967 · S/N 17256069 N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869 N286SPStratus Aviation LLC DBA · Vacaville, CABuilt 1999 · S/N 172S8238 N2870UKline Kevin J · Clyde, OHBuilt 1963 · S/N 17250470 N2871USt Clair Dustin W · Cloverdale, CAS/N 17250471 N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872 N2873QCloud Dancer Aviation Inc · Deland, FLBuilt 1971 · S/N 17259873 N2874LSchirack John · Decatur, INBuilt 1967 · S/N 17256074 N2875LDavenport Ross K · Raleigh, NCBuilt 1967 · S/N 17256075 N2875QLani Lea Sky Tours LLC · Honolulu, HIBuilt 1971 · S/N 17259875 N2875UWalter Karl F · Fayetteville, GABuilt 1963 · S/N 17250475 N2876UPianalto David · Wichita, KSBuilt 1963 · S/N 17250476 N2877UMelin James · Livingston, MTBuilt 1963 · S/N 17250477 N2878LHolbrook David A · Toccoa, GABuilt 1967 · S/N 17256078 N2878QFields Williams H · Greensboro, NCBuilt 1971 · S/N 17259878 N2879QBlue Side Aviation LLC · Tampa, FLBuilt 1971 · S/N 17259879 N287SPRose Bros Inc · Lingle, WYBuilt 1999 · S/N 172S8239 N2880EDemulling Michael C · New Richmond, WIBuilt 1978 · S/N 17271358 N28811B D Aviation LLC · Sauget, ILBuilt 2004 · S/N 17281232 N2881LCore Alan L · Indianola, IABuilt 1967 · S/N 17256081 N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881 N2883UPaul Aviation LLC · Sault Sainte Marie, MIBuilt 1963 · S/N 17250483 N2884UEast Tenn Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 17250484 N2885LBlevens George A Jr · Franklin, KYS/N 17256085 N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885 N2885UEda4 LLC · Cresson, TXBuilt 1963 · S/N 17250485 N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886 N2886UVon Linsowe David J · Vero Beach, FLBuilt 1963 · S/N 17250486 N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360 N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087 N2888QChilds William C · Bridgeport, ALS/N 17259888 N2888UBodo Martin Trustee · Los Altos Hills, CABuilt 1963 · S/N 17250488 N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089 N288MESouth Dakota State University · Brookings, SDBuilt 2000 · S/N 172S8548 N288SCDelta Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13240 N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890 N2890URedley Andrew Scott · Maryville, TNBuilt 1963 · S/N 17250490 N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363 N2892LSellers Michael E · Clam Gulch, AKBuilt 1967 · S/N 17256092 N2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364 N2893UMerrell Jon P · Wolcott, NYBuilt 1963 · S/N 17250493 N2894LJohnson Nancy B · Vestavia Hills, ALBuilt 1967 · S/N 17256094 N2894QFerkin Mark A · Caldwell, IDBuilt 1971 · S/N 17259894 N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895 N2896EFlight Club 502 Inc · Louisville, KYBuilt 1978 · S/N 17271365

Back to AD 90-06-03 R1