Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N25FAFly Rite Aviation LLC · Fort Myers, FLBuilt 1973 · S/N 34-7450047 N25MHumble Ventures Inc · Tempe, AZBuilt 1965 · S/N 24-4221 N25PRInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1511 N2601RHarden Aviation LLC · Washington, PABuilt 1969 · S/N 28R-35223 N2607RSullivan Christopher · Duson, LAS/N 28R-35226 N260BCFlying J LLC · Bulverde, TXBuilt 1967 · S/N 24-4606 N260CDMarlow Bruce D - Trustee · Nevada City, CABuilt 1966 · S/N 24-4389 N260DTInternational Air Services Inc Trustee · Carson City, NVS/N 24-4995 N260GCFeline Health Inc · Hampstead, NCBuilt 1969 · S/N 24-4834 N260JFKropp Christian Trustee · Azle, TXBuilt 1965 · S/N 24-4196 N260NCYounhorsh Sales LLC · Wilmington, DEBuilt 1969 · S/N 24-4855 N260PCRegistered aircraftBuilt 1965 · S/N 24-4125 N260SCN260sc Partnership Group LLC · Ogden, UTBuilt 1964 · S/N 24-3678 N2610Avionicos Corp · Nokomis, FLBuilt 1977 · S/N 34-7770428 N2610RStable Aviation LLC · Eagan, MNBuilt 1969 · S/N 28R-35229 N2611MOlsen Robert F · Chatham, MABuilt 1977 · S/N 28R-7803138 N2618MSoltis Stephen T · Kingsport, TNBuilt 1977 · S/N 34-7870089 N261EZZokpodo Emmanuel K · Sacramento, CABuilt 1975 · S/N 28R-7635087 N262XPrice Scott K · Sparks, MDBuilt 1973 · S/N 28R-7335286 N2634RRichardson Michael T · Inver Grove Hghts, MNS/N 28R-35236 N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633 N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93 N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157 N266WLowell James · Tucson, AZS/N 24-1923 N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040 N2679QMorgan Jonathan P · Mooresville, NCBuilt 1977 · S/N 32R-7780260 N267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1976 · S/N 347670332 N2680QTaylor Clarence J · Pipestone, MNBuilt 1977 · S/N 32R-7780261 N26893Goodman Harold Wayne · Clovis, CAS/N 28R-30679 N2696RBowen Diane M · Newbury, MABuilt 1969 · S/N 28R-35248 N2697MCmp Aviation LLC · Williamsville, MOBuilt 1977 · S/N 28R-7837097 N2698MBearce Larry James Jr · Solon, IABuilt 1977 · S/N 28R-7803139 N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798 N26BWBestul Greg · Lester Prairie, MNBuilt 1967 · S/N 30-1559 N26CXCiholas Philippe A · Sedgwick, KSBuilt 1970 · S/N 244949 N26JTBohning Aviation LLC · Ponchatoula, LABuilt 1974 · S/N 28R-7535021 N26RDPacific North Air LLC · Portland, ORS/N 34-7350167 N26RJRoedel Road Co · Kewadin, MIBuilt 1969 · S/N 30-1886 N2702RBas Part Sales LLC · Greeley, COS/N 28R-35252 N2703RWorthington Gary M · West Berlin, NJBuilt 1969 · S/N 28R-35253 N2704RStratus Equity LLC · Helena, MTBuilt 1969 · S/N 28R-35254 N2705RCenterline Aviation LLC · Nolensville, TNBuilt 1969 · S/N 28R-35255 N2707RCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1969 · S/N 28R-35258 N2712RSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28R-35259 N2719CBrown Kevin Charles · Round Rock, TXBuilt 1977 · S/N 28R-7803034 N2719RJenkins Bruce D · New Market, MDBuilt 1969 · S/N 28R-35265 N2722RPerez Angel L · Arecibo, PRBuilt 1969 · S/N 28R-35268 N272LCPen And Pilot Inc · Flagler Beach, FLBuilt 1972 · S/N 28R-7235059 N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275 N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279

Back to AD 97-01-01 R1