Skip to content

Registered aircraft · 20,687

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.

N9966VLeisner David L · Palmer, AKBuilt 1974 · S/N 17264584 N9968FSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 1997 · S/N 17280208 N9968LMw Flying LLC · Sanford, NCBuilt 1986 · S/N 17276654 N9968VCynthiana Flying Group Corp · Cynthiana, KYBuilt 1974 · S/N 17264586 N99697Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276494 N9969BGreenwalt Bert · Jonesboro, ARBuilt 1982 · S/N 172RG1101 N9969VCosta William · Farmington Hills, MIBuilt 1974 · S/N 17264587 N996CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280321 N996MWWiehl In The Sky LLC · Mount Juliet, TNBuilt 1973 · S/N 17262434 N996RAN996ra LLC · Palm City, FLBuilt 1998 · S/N 17280404 N996SAEp Aero LLC · Parkton, MDBuilt 2002 · S/N 172S9096 N996TALi LLC · Seattle, WABuilt 2000 · S/N 172S8521 N996WWPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1999 · S/N 17280726 N99700Lee Rich · Carlsbad, CABuilt 1985 · S/N 17276496 N99709Long Island Aviators LLC · Seaford, NYBuilt 1985 · S/N 17276498 N9970VSpalding Flying Club LLC · Griffin, GABuilt 1974 · S/N 17264588 N99712Nesher Aviation II LLC · Jacksonville, FLBuilt 1985 · S/N 17276499 N99715N99715 LLC · Wheeling, ILS/N 17276501 N9971EGuerrero-Reyes Fernando G · Princeton, NJBuilt 1979 · S/N 17272304 N99725Holladay Aviation LLC · Jacksonville, FLBuilt 1985 · S/N 17276502 N9972VMotley Charlotte J · Summerdale, ALBuilt 1974 · S/N 17264590 N9973BMajor Air LLC · Charleston, SCBuilt 1982 · S/N 172RG1103 N99744Christiansen Aviation LLC · Wilmington, DEBuilt 1985 · S/N 17276503 N9974BAppalachian Aviation LLC · Harrisonburg, VABuilt 1982 · S/N 172RG1104 N99750Kool Wings Leasing LLC · Indianapolis, INBuilt 1985 · S/N 17276504 N99759Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276506 N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, COBuilt 1985 · S/N 17276507 N99770Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276508 N9977VLunceford James A · Stanchfield, MNBuilt 1974 · S/N 17264595 N99783Alexander Todd · Westhampton, MABuilt 1985 · S/N 17276510 N9978FSloan Jeffrey L · Hopland, CABuilt 1997 · S/N 17280203 N997MCAeroventures Flying Club Inc · Lilburn, GABuilt 1997 · S/N 17280039 N997RAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280028 N997SEAero Equities LLC · Ventura, CABuilt 1978 · S/N 17271571 N9981FKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1997 · S/N 17280142 N9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeBuilt 1974 · S/N 17264599 N99826Cp Aviation · Santa Paula, CABuilt 1985 · S/N 17276514 N99832Watch Ya Head Aviation 1 LLC · Zionsville, INBuilt 1985 · S/N 17276515 N9983VHeyman William L · Santa Fe, NMBuilt 1974 · S/N 17264601 N9984VValley Drug Of Malta Inc · Malta, MTBuilt 1974 · S/N 17264602 N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107 N99870Christiansen Aviation LLC · Wilmington, DES/N 17276519 N99871Civil Air Patrol · Maxwell Afb, ALS/N 17276520 N99872Rps Holdings N99872 LLC · Magnolia, TXS/N 17276521 N9987VKaplan Steven M · North Monmouth, MES/N 172-64605 N99881Civil Air Patrol · Maxwell Afb, ALS/N 17276523 N99885Az2025 LLC · Miami, FLS/N 17276524 N9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeBuilt 1974 · S/N 17264606 N9989VPace Dusty · Pendleton, ORBuilt 1974 · S/N 17264607 N998CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12158

Back to AD 90-06-03 R1