Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N99697Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276494 N9969UBlair Denton Cassity III · Morehead, KYBuilt 1977 · S/N AA5A0369 N9969VCosta William · Farmington Hills, MIBuilt 1974 · S/N 17264587 N996CCL-Bird LLC · Hood River, ORBuilt 2000 · S/N 9914CC N996JHMountain John · Wrightstown, WIBuilt 1971 · S/N 28-7125529 N996KHatbright Farm LLC · Wilmington, DES/N GS2 N996MWWiehl In The Sky LLC · Mount Juliet, TNBuilt 1973 · S/N 17262434 N996PJClark James E · Columbia, SCBuilt 2002 · S/N 23456 N996RVMcgee Michael G · Lake Oswego, ORBuilt 1996 · S/N 001 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 N9970WSkrabacz Joseph A · Niceville, FLBuilt 1967 · S/N 28-23517 N99712Nesher Aviation II LLC · Jacksonville, FLBuilt 1985 · S/N 17276499 N99715N99715 LLC · Wheeling, ILS/N 17276501 N9971DAhern Daniel Patrick · Oxford, NCS/N 22-6762 N9971EGuerrero-Reyes Fernando G · Princeton, NJBuilt 1979 · S/N 17272304 N9971WMorris Elaine · Moorestown, NJBuilt 1967 · S/N 28-23518 N9971YSchad Tom J · Gainesville, TXBuilt 1963 · S/N 7GCB-182 N99725Holladay Aviation LLC · Jacksonville, FLBuilt 1985 · S/N 17276502 N9972VMotley Charlotte J · Summerdale, ALBuilt 1974 · S/N 17264590 N9973DRoadarmel Brandon L · Three Forks, MTS/N 22-6764 N99744Christiansen Aviation LLC · Wilmington, DEBuilt 1985 · S/N 17276503 N9974QJohnson Timothy D · Chapel Hill, NCBuilt 1953 · S/N 18-4033 N99750Kool Wings Leasing LLC · Indianapolis, INBuilt 1985 · S/N 17276504 N99759Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276506 N9975WPoole Terrell W · Rigby, IDBuilt 1967 · S/N 28-23523 N99765Tactical Intergriated Training Solutions LLC · Colorado Springs, COBuilt 1985 · S/N 17276507 N9976DHamon Troy R · King Salmon, AKBuilt 1959 · S/N 22-6767 N99770Civil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276508 N9977CSchuster Jacob M · Mchenry, ILBuilt 1972 · S/N 28-7225525 N9977DMesserla David M · Manhattan, KSBuilt 1959 · S/N 22-6768 N9977VLunceford James A · Stanchfield, MNBuilt 1974 · S/N 17264595 N9977WN9977w LLC · Easley, SCS/N 28-23525 N9977YBenninger Timothy A · Cobleskill, NYBuilt 1967 · S/N 18-8587 N99783Alexander Todd · Westhampton, MABuilt 1985 · S/N 17276510 N9978RButts James A · Gainesville, GABuilt 1960 · S/N TD-415 N997ABBentrup Reinhard F · Goleta, CABuilt 1993 · S/N 2377 N997CCWunorse Openslae LLC · Dallas, TXBuilt 2000 · S/N 9915CC N997NCVega Gustavo E · Watertown, NYBuilt 1965 · S/N 28-20817 N997SEAero Equities LLC · Ventura, CABuilt 1978 · S/N 17271571 N997SGRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816562 N997UPPotti Noah · Kalispell, MTBuilt 1950 · S/N 20-246 N9980WAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-23528 N9981RMatthias Robert C · Gainesville, FLBuilt 1960 · S/N TD-419 N9981UExpedition Air LLC · Antioch, CABuilt 1977 · S/N AA5A0381 N9981VWeeks Richard F Jr · Portsmouth, NHFirst renewal noticeBuilt 1974 · S/N 17264599 N99826Cp Aviation · Santa Paula, CABuilt 1985 · S/N 17276514 N9983VHeyman William L · Santa Fe, NMBuilt 1974 · S/N 17264601 N9984RMoloney Phillip M · Lexington, KYS/N TD-420

Back to AD 79-10-03 R2