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.

N7192PBest Equipment Leasing LLC · Bakersfield, CABuilt 1960 · S/N 24-2362 N7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeBuilt 1960 · S/N 24-2363 N7194CCivil Air Support LLC · Phoenix, AZBuilt 1975 · S/N 28R-7635096 N7196YAircraft & Aviation Professionals LLC · Coldwater, MIS/N 30-220 N7199PLee Jeffrey L · Cameron, MTBuilt 1961 · S/N 24-2370 N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223 N719WTTait Jesse L · Belton, TXBuilt 1979 · S/N 34-7970362 N71ADSons Aviation LLC · Moody, ALS/N 30-1524 N71BBMitchell Trans · Timnath, COFirst renewal noticeBuilt 1967 · S/N 30-1539 N71EFSandercock Mark L · Pewaukee, WIBuilt 1972 · S/N 28R-7235176 N71GMEtheredge Mark · Pell City, ALBuilt 1969 · S/N 30-1959 N71GTHazduff LLC · Plainfield, INBuilt 1969 · S/N 30-1801 N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261 N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386 N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224 N7203PGorge Fast Aviation LLC · Hood River, ORBuilt 1960 · S/N 24-2373 N7204CHousley Communications Inc · San Angelo, TXBuilt 1975 · S/N 32R-7680042 N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374 N7206YSkyflite LLC · Hillsboro, ORS/N 30-232 N7207PSteinbach Philipp · Bentonville, ARBuilt 1960 · S/N 24-2377 N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235 N720GCCox Gary E · Davis, CABuilt 1972 · S/N 28R-7235317 N7210PBirdwell David W · Richmond, TXBuilt 1960 · S/N 24-2380 N7211PWhite Jordan H · Gold Beach, ORBuilt 1960 · S/N 24-2381 N7211YBeers Jason · Girard, OHS/N 30-237 N7216YMerriwether David E · Whitesburg, GABuilt 1963 · S/N 30-242 N7217PNewman Samuel M · Taylorsville, UTBuilt 1960 · S/N 24-2389 N7220PHench Martin Stewart · La Verne, CABuilt 1960 · S/N 24-2392 N7221PBuhrmeister Timothy J · Centereach, NYBuilt 1960 · S/N 24-2393 N7224YDistel Harold M · Williamson, GABuilt 1964 · S/N 30-246 N7225PSuperior Aviation LLC · Metairie, LABuilt 1960 · S/N 24-2399 N7225YTwin Cam Holdings LLC · Union City, TNBuilt 1964 · S/N 30-248 N7226YGilbert Douglas A · Weston, FLBuilt 1964 · S/N 30-249 N7227YClearview Aerial Solutions LLC · Rogersville, TNS/N 30-250 N722AVMcdaniel Ibarra Professional Services Inc · Palm Desert, CABuilt 1976 · S/N 32R-7780029 N722PSSzendrey James J · Glendale, AZBuilt 1978 · S/N 34-7870125 N722RATotal Prf LLC · Lewes, DEBuilt 1972 · S/N 34-7250352 N722WMPegasus Enterprises LLC · Granbury, TXS/N 28R-7435045 N7230PFranks Orlan H III · Belton, TXBuilt 1960 · S/N 24-2404 N7230YVyas Shiven P · Chino Hills, CABuilt 1964 · S/N 30-254 N7232POntiveros Vicente III · New Braunfels, TXS/N 24-2406 N7233YPacific North Air LLC · Portland, ORBuilt 1964 · S/N 30-257 N7234CConfidential LLC · Lutz, FLBuilt 1975 · S/N 32R-7680043 N7234PEagle Ag Services LLC · Lees Summit, MOBuilt 1960 · S/N 24-2408 N7236UWuhu Industries LLC · Canby, ORS/N 32R-7780298 N7239PMccabe Gregory · Melbourne Beach, FLBuilt 1960 · S/N 24-2413 N723CFCay Air Inc · Largo, FLBuilt 1977 · S/N 32R-7780508 N723JSAlbertson James M · Westville, FLBuilt 1967 · S/N 30-1512 N723RANeron II LLC · Lewes, DES/N 34-7350090 N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264

Back to AD 97-01-01 R1