Skip to content

Registered aircraft · 142

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:80-21-12-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:80-21-12-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:80-21-12-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:80-21-12-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:80-21-12-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:80-21-12-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.

N37WRStill Flying LLC · Carlisle, PABuilt 1975 · S/N 0721 N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768 N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771 N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773 N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774 N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775 N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776 N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778 N3812FGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1977 · S/N 0780 N3813FN3813f Inc · Wilmington, DEBuilt 1977 · S/N 0781 N3814FSnuffer Michael K · Reno, NVBuilt 1977 · S/N 0782 N3815FOrr Charles W III · San Ramon, CABuilt 1977 · S/N 0783 N3816FHotzel Jeffrey F · Gladstone, MOBuilt 1977 · S/N 0784 N3817FKirker Howard A · Rio Verde, AZS/N 0785 N3819FBuntings Grassroots Aviation LLC · Selbyville, DES/N 0787 N3821FKennedy Karen E · Gulf Breeze, FLBuilt 1977 · S/N 0789 N3822FBelser Mark · Avon, OHBuilt 1977 · S/N 0790 N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791 N4008LBooth James L · Bozeman, MTS/N 0824 N4011LSmith Jeffrey S · Linden, MIBuilt 1978 · S/N 0825 N434RBBrown Brian M · Downey, CABuilt 1976 · S/N 0740 N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752 N4555WSan Diego Aerobatics LLC · San Diego, CABuilt 1976 · S/N 0741 N455ETLakes Aircraft Inc. · Maumee, OHBuilt 1975 · S/N 0711 N464JWWatts John C · Matthews, NCBuilt 2023 · S/N 1219 N474CTThomas Wayne H · Dover, DEBuilt 1981 · S/N 1002 N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770 N503GLWomack Thomas G · Lonoke, ARS/N 0503 N506GLKutschera Theodore C III · Callicoon, NYBuilt 1973 · S/N 0506 N507GLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 507 N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508 N511GLFrerichs Brent A · Sandpoint, IDBuilt 1975 · S/N 0511 N521KD S Batchelor Holdings LLC · Clark, SDBuilt 1998 · S/N 2JF N52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761 N530HSCti Aircraft Leasing LLC · Memphis, TNBuilt 2014 · S/N 1205 N53GLWaco Classic Aircraft Corp DBA · Battle Creek, MIBuilt 2015 · S/N 1206 N53VCAbita Skies LLC · Robert, LAS/N 1009 N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828 N5603LKushnir Borys G · Tamuning, GUBuilt 1974 · S/N 0702 N5613LRed Rock Flyers LLC · Flagstaff, AZBuilt 1974 · S/N 0704 N5761GNelson Ken · Caledonia, WIBuilt 1980 · S/N 0831 N5761ZHannibal Aviation LLC · Stamford, CTBuilt 1980 · S/N 0834 N5762BAssociated Aircraft LLC · San Diego, CABuilt 1980 · S/N 0833 N5762DNavar Thomas R · El Paso, TXBuilt 1981 · S/N 1004 N5762GBrown Patrick T Trustee · Osceola, WIBuilt 1981 · S/N 1003 N5886LCook Charles N · Lakeside, TXBuilt 1975 · S/N 0707 N5ZMDakota & Skyy LLC · Louisville, COBuilt 1975 · S/N 0722 N6016LAssociated Aircraft LLC · San Diego, CABuilt 1975 · S/N 0710 N6022LIrving Donald J · Deland, FLBuilt 1975 · S/N 0712 N6036LCrestair Air LLC · Dover, DEBuilt 1975 · S/N 0713

Back to AD 80-21-12 R1