Skip to content

Registered aircraft · 26,231

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-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N3632KPerry George E · Cheyenne, WYBuilt 1946 · S/N 22324 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3633JMicrokit Solutions LLC · Bridgeview, ILS/N 15064933 N3633VPatrick Michael D · Port Saint Joe, FLBuilt 1948 · S/N 14904 N3634JLuft Inc · North Fort Myers, FLBuilt 1966 · S/N 15064934 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803 N3634NRound Engine Aero · Nashville, MIBuilt 1947 · S/N 22892 N3635LRobinson Edgar M · Cairo, GABuilt 1965 · S/N 17253804 N3635VTz Airways 1 LLC · Avon Park, FLBuilt 1975 · S/N 15076570 N3636LFllsend Aviation LLC · Kaysville, UTS/N 17253805 N3636SGriesman Scott W · Sandy Valley, NVBuilt 1963 · S/N 17250836 N3636VMorgan Jarrett A · Amherst, WIBuilt 1948 · S/N 14907 N3637HDe Young Robert · Napa, CABuilt 1946 · S/N 4262 N3637KAns Construction LLC · Swedesboro, NJBuilt 1946 · S/N 22308 N3638JEngelskirger Karl D · Valley City, OHBuilt 1966 · S/N 15064938 N3638KShelton Greg N Trustee · Collinsville, OKBuilt 1946 · S/N 22329 N3638VHope Virginia L · Georgetown, OHS/N 15076571 N3639EKelso Samuel G Trustee · Louisville, TNBuilt 1947 · S/N 7AC-6961 N3639JPrima County Community College · Tucson, AZBuilt 1966 · S/N 15064939 N3639KAmundson Daryl DBA · Blue Earth, MNBuilt 1946 · S/N 22332 N3639LAzimuth Partners II LLC · Sanford, FLBuilt 1965 · S/N 17253808 N363GMMccormick Gregory W · Athens, ALBuilt 2022 · S/N 5542 N3640JCovington Brian · Florence, ALBuilt 1966 · S/N 15064940 N3640LHussain Mahmoud T · Miami, FLBuilt 1965 · S/N 17253809 N3640SPetersen Jacob R · Wasilla, AKS/N 17250840 N3640VSeaton Robert D · Seguin, TXBuilt 1948 · S/N 14911 N3641LSeaplanes R Fun Inc · Wilmington, DEBuilt 1965 · S/N 17253810 N3641VWright John C · Windham, MEBuilt 1975 · S/N 15076573 N3642HMccoy Bill · Deland, FLBuilt 1946 · S/N 4267 N3642LMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253811 N3643SMaycroft David · Cary, ILBuilt 1963 · S/N 17250843 N3644JBoggs Dilan · Nicholls, GABuilt 1966 · S/N 15064944 N3644LHobbie Roy Lee · Cynthiana, KYBuilt 1965 · S/N 17253813 N3644SMurray William · East Jordan, MIBuilt 1963 · S/N 17250844 N3645EBenham Aviation LLC · Enid, OKBuilt 1947 · S/N 7AC-6965 N3645LRegistered aircraftBuilt 1965 · S/N 17253814 N3645VBryan Joseph J · Gilbert, SCS/N 14916 N3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationBuilt 1966 · S/N 15064946 N3646LRobert Roger J · Gardner, MABuilt 1965 · S/N 17253815 N3646SCummings Larry D · Clarence, NYBuilt 1966 · S/N 17254827 N3646VThompson Randy L · Anderson, CABuilt 1948 · S/N 14917 N3647LEmmett Kerry N · Greeneville, TNBuilt 1965 · S/N 17253816 N3648LGlenn William · Marion, NCBuilt 1965 · S/N 17253817 N3648NTrower Charles T · Scobey, MTBuilt 1947 · S/N 22908 N3648VNeary Russ P · Plympton, MABuilt 1948 · S/N 14919 N3649LArmour Walton H · Alliance, OHBuilt 1965 · S/N 17253818 N364SRSales Joe H DBA · Seminole, TXBuilt 1964 · S/N 17251558 N3650JPostle Jessica Grace · Newark, OHBuilt 1966 · S/N 15064950 N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819 N3651VEastern Stearman Inc Trustee · Leesburg, VABuilt 1948 · S/N 14922

Back to AD 94-05-05 R1