Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N136XNautical Skies LLC · Helena, MTS/N D-6215 N137TWDixon Daniel N · Millersville, MDBuilt 1974 · S/N D-9631 N1388ZSterling Michael · Purcell, OKBuilt 1961 · S/N D-6807 N1389ZNachtigal Joel K · Bulverde, TXBuilt 1961 · S/N D-6814 N138GGardiner Alan H · Waterford, CTBuilt 1964 · S/N D-7564 N138TWSulka Andrew Mark · Pittsburgh, PABuilt 1974 · S/N D-9647 N1390ZGm Aviation LLC · Woodridge, ILBuilt 1961 · S/N D-6833 N1392ZRautiola Charles A · Rosemount, MNBuilt 1961 · S/N D-6822 N1393ZSdd LLC · Great Falls, MTBuilt 1961 · S/N D-6813 N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012 N1397ZJ&W Air LLC · Asheville, NCBuilt 1961 · S/N D-6819 N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083 N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652 N13ARKeen Daniel Edward · Peoria, AZBuilt 1954 · S/N D-3885 N13EGo Leasing Co · Phillipsburg, KSBuilt 1952 · S/N D-3259 N13PNWillis Ted A · Fayetteville, ARBuilt 1957 · S/N D-5231 N13RTWoodhouse Dave · Battle Creek, MIBuilt 1962 · S/N D-6954 N13XXNantz William G Jr · Raleigh, NCS/N D-6467 N1400GRotor Spec Aviation LLC · Star, IDBuilt 1961 · S/N D-6890 N1404GJkc Farm LLC · Chinook, MTBuilt 1961 · S/N D-6893 N1405GLefever Larry R · Fall City, WABuilt 1961 · S/N D-6891 N1408GMorris Travis T · Chandler, AZBuilt 1961 · S/N D-6892 N140UCJackson Donald R · Lexington Park, MDBuilt 1951 · S/N D-2822 N1412GBruch Lance J · Emmetsburg, IABuilt 1961 · S/N D-6895 N14147Pugsley Len · East Wenatchee, WABuilt 1952 · S/N D-3145 N1416GNixon Terry L · Enid, OKBuilt 1961 · S/N D-6896 N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550 N1417GRomney James J · Fruit Heights, UTBuilt 1962 · S/N D-6902 N1419GMcneal James B · Beaufort, SCBuilt 1962 · S/N D-6900 N141GWaller Steven M · Sterling, COBuilt 1954 · S/N D-3975 N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634 N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995 N1422LTonka Seaplanes LLC · Minnetonka, MNBuilt 1961 · S/N D-6584 N1427GCarter Geoffrey R · Ormond Beach, FLBuilt 1962 · S/N D-6903 N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020 N142MPeterson Dana Timothy · Eldersburg, MDBuilt 1960 · S/N D-6585 N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013 N1437GMason Mark D · Brighton, COBuilt 1962 · S/N D-6910 N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664 N1444GLam Lawrence Y · Rosemead, CAS/N D-15002 N1448GMotions Dynamics LLC · Campbellsville, KYBuilt 1962 · S/N D-6916 N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633 N144FFoster Gary E · Kress, TXBuilt 1963 · S/N D-7142 N144GMWilliams David · Golden, MOBuilt 1962 · S/N D-7010 N144LMHobert Robert W Trustee · Penn Valley, CABuilt 1957 · S/N D-5267 N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496 N1454GN1454g LLC · Knoxville, TNBuilt 1962 · S/N D-6914 N1455GNell James E · Pagosa Springs, COBuilt 1962 · S/N D-6920 N1459GBeeson Chris · Graford, TXBuilt 1962 · S/N D-6917 N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334

Back to AD 94-20-04 R2