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.

N28UPStoddard Donald W · Great Falls, MTBuilt 1973 · S/N 28R7335386 N2900HStevens Cloyce B Jr · Tillar, ARS/N 34-7970342 N2904PRandall Airlines LLC · Wendell, NCBuilt 1965 · S/N 24-4191 N2907DSandhu Tejpal · Southlake, TXS/N 34-7970348 N2907QTweto Matthew E · Montgomery, TXS/N 34-7970349 N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324 N2908XArtsplane LLC · Parker, TXS/N 34-7970352 N2912VSoaring Twins LLC · Pikeville, NCS/N 34-7970354 N2914RLandrith Robert L · Mustang, OKBuilt 1969 · S/N 28R-35327 N2917RCzarnecki Neil A · Racine, WIBuilt 1969 · S/N 28R-35328 N2919QRobert D Grace LLC · Amarillo, TXS/N 28R-7703079 N291MCGonzalez Joseph III · Saginaw, TXBuilt 1972 · S/N 28R-7335026 N2921QAmbler Aviation LLC · Ambler, PAS/N 32R7780267 N2921RZiegler James F · Darwin, MNBuilt 1969 · S/N 28R-35329 N2922QWw Aero LLC · Jonesboro, ARS/N 32R-7780268 N2922ULowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1979 · S/N 34-7970377 N2922WHiwassee Aviation LLC · Calhoun, TNS/N 34-7970378 N2922YBeckstrand John James Wendell · Eagan, MNS/N 28R-8031029 N2924CFour Star Aero Services Inc · Palm Coast, FLS/N 34-7970379 N2924LSeidel Robert P · Belle Mead, NJS/N 34-7970381 N2924MJones Joshua D · Gallatin Gateway, MTBuilt 1977 · S/N 28R-7837105 N29257Blackwell Aviation LLC · Tacoma, WABuilt 1979 · S/N 34-7970244 N2925RSpeedbird Aviation Alpha Charlie LLC · Glenn Heights, TXBuilt 1969 · S/N 28R-35330 N2927MCooney Francis M · Sunriver, ORBuilt 1977 · S/N 28R-7837106 N2927QWifa (Washington International Flight Acad) LLC · Gaithersburg, MDS/N 28R-7737043 N292REStructure Inc · Neenah, WIBuilt 1965 · S/N 30-768 N292RMJunk Troy A · Wshngtn Ct Hs, OHBuilt 1968 · S/N 28R-30955 N2930QL A B Flying Service Inc · Renton, WAS/N 32R-7780269 N2930RSouthern Warriors International Inc · Port Saint Lucie, FLBuilt 1969 · S/N 28R-35332 N2930VDale Aviation Inc · Rapid City, SDS/N 34-7970384 N2931LPlanesmen LLC · Liberal, KSS/N 34-7970387 N2931MNsain Flight Ops LLC · Fort Worth, TXBuilt 1977 · S/N 28R-7803154 N2931QSky Dasher Inc · Wilmington, DES/N 32R-7780270 N2933QThomas Mark E · Corpus Christi, TXBuilt 1977 · S/N 34-7770200 N293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844176 N293MGGeorgia Aviation Authority · Eastman, GABuilt 2015 · S/N 2844155 N2940QSkyhawk Flying Club Inc · Omaha, NES/N 28R-7737044 N2940RRespass Keith D · Bluffton, SCBuilt 1969 · S/N 28R-35334 N29435Cazares James · Barrington, ILBuilt 1979 · S/N 34-7970247 N2943QAurand Bradley · Selinsgrove, PABuilt 1977 · S/N 32R-7780272 N2945RHuestis Gary M · Blackfoot, IDBuilt 1969 · S/N 28R-35339 N29466Lake Area Technical College · Watertown, SDBuilt 1979 · S/N 34-7970257 N2947Moran M Michael · Chico, CAS/N 24-4681 N2949EReve Air Inc · La Place, LABuilt 1979 · S/N 34-7970397 N294FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844177 N2950RRebecca Aviatrix LLC · Columbus, INS/N 28R-35340 N2952RTowers Roland M · Shady Shores, TXBuilt 1969 · S/N 28R-35344 N2953QW-Wingmen LLC · Simi Valley, CABuilt 1977 · S/N 28R-7703084 N295BPQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 347570249 N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178

Back to AD 97-01-01 R1