Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N9864GHoppers James W Jr · Milan, TNBuilt 1971 · S/N 17259764 N9865GWheeler John W · River Ranch, FLBuilt 1971 · S/N 17259765 N9866G198 Main Street Aviation LLC · Sullivan, WIBuilt 1971 · S/N 17259766 N9867GRegistration Pending · Miami, FLRegistration pendingBuilt 1971 · S/N 17259767 N98680Fischer Alfred M DBA · Genoa City, WIS/N 15069125 N9868GHoff Brian A · Hackettstown, NJBuilt 1971 · S/N 17259768 N9869GWilliams Richard H · Lockport, NYBuilt 1971 · S/N 17259769 N9870GThacker William E · Chenoa, ILS/N 17259770 N9874GKorn Jeffrey J · Marietta, GABuilt 1971 · S/N 17259774 N9875G1 Aircraft LLC · Kissimmee, FLBuilt 1971 · S/N 17259775 N9875MKaelin Robert A · Fayetteville, ARBuilt 1972 · S/N 17260575 N9876GKentucky Lake Aviation LLC · Huntingdon, TNBuilt 1971 · S/N 17259776 N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777 N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778 N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780 N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781 N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783 N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784 N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788 N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789 N988MVMiller James A · Granada Hills, CABuilt 1967 · S/N T210-0284 N9891GOuellette Kevin E · Frederick, OKBuilt 1971 · S/N 17259791 N9892GFritz John P · Belvidere, NJBuilt 1971 · S/N 17259792 N9894G1s6 Flying Club Inc · Sandpoint, IDS/N 17259794 N9895GKellerman Roger B · Rockford, ILBuilt 1971 · S/N 17259795 N9899GWings Over Texas LLC · Denton, TXBuilt 1971 · S/N 17259799 N98BVUSA Air LLC · Ruskin, FLBuilt 1974 · S/N 15075695 N98EMGreen Tool & Die Co LLC · Honesdale, PABuilt 1968 · S/N 17256804 N98GCGarcia Alexandra · Pompano Beach, FLBuilt 1968 · S/N 17257750 N98SWGankas Christopher · Ventura, CABuilt 1976 · S/N 177RG1090 N98ZTSharp Paul A II · Apollo Beach, FLBuilt 1971 · S/N 17259956 N9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeS/N A1500456 N9906GNielson Donald L · Independence, ORBuilt 1973 · S/N A1500457 N9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLBuilt 1973 · S/N A1500459 N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690 N9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeBuilt 1973 · S/N A1500464 N9914GKunas Matthew · Akron, OHBuilt 1973 · S/N A1500465 N991NADatkuliak Michael C · Beallsville, OHBuilt 1965 · S/N 17253709 N9922GAguilar William A · Puyallup, WABuilt 1973 · S/N A1500468 N9924AAbner Cody J · Cleburne, TXBuilt 1966 · S/N 18256978 N9934GDiorio Christopher J · Melba, IDBuilt 1973 · S/N A1500471 N993DWDeadstick Holdings LLC · Laguna Niguel, CABuilt 1963 · S/N 18255149 N994JPHinen Paul H · Soap Lake, WABuilt 1973 · S/N 15074483 N994NACurry Lloyd F · Karnack, TXBuilt 1966 · S/N 17254820 N99501Bennett Gary R · Anchorage, AKBuilt 1971 · S/N 18260598 N9952MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1976 · S/N 207-00345 N995NABucher Devin V · Kalispell, MTBuilt 1966 · S/N 17255575 N995VZMeyerowitz Noah A · Great Barrington, MABuilt 1974 · S/N 177RG0478 N9964CTakle Management LLC · Bethany, OKBuilt 1964 · S/N 18255519 N996AKSierra Sky Aviation LLC · Kalispell, MTBuilt 1970 · S/N U20601519

Back to AD 72-03-03 R3