Skip to content

Registered aircraft · 22,413

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N2915MBlue Sky Aviation Association Inc · Readington, NJS/N 28-7911244 N2915QEtheredge Mark · Pell City, ALS/N 28-7716122 N2915TSierra Canyon Enterprises · Big Bear City, CABuilt 1979 · S/N 28-7921041 N29170Kuhlmann Connor · Ada, MIBuilt 1979 · S/N 32-7940131 N29172Reutter David C · Mount Kisco, NYBuilt 1979 · S/N 32-7940132 N2917RCzarnecki Neil A · Racine, WIBuilt 1969 · S/N 28R-35328 N2917TSims John H · Flemingsburg, KYS/N 28-7990553 N2918BMorris Robert B · Billings, MTBuilt 1979 · S/N 28R-7918219 N2918DMelton Derrick · Midland, TXBuilt 1979 · S/N 28-7911245 N2918QConner W Larry · Los Lunas, NMS/N 28-7790420 N2918XFlight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-7916543 N2919ARegistration Pending · Dublin, GARegistration pendingS/N 28-7916544 N2919LBart'S Flying Service Inc · Storm Lake, IAS/N 28-7990556 N2919QRobert D Grace LLC · Amarillo, TXS/N 28R-7703079 N2919UFrix Richardd · Bluffdale, UTBuilt 1979 · S/N 28R-7918220 N291CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881007 N291HAChandler Air Service Inc · Chandler, AZBuilt 1966 · S/N 28-22138 N291HPBurke Matthew Joel · Maricopa, AZBuilt 2003 · S/N 2843578 N291LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020013 N291LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881168 N291MCGonzalez Joseph III · Saginaw, TXBuilt 1972 · S/N 28R-7335026 N291MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843773 N291MKPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842086 N291WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020052 N2920WBrown Jeffrey C · Bozeman, MTBuilt 1965 · S/N 28-2435 N29215Lzl Aviation LLC · Wilmington, DEBuilt 1979 · S/N 28-7916420 N29218Israelsen Martin · Santa Rosa Beach, FLBuilt 1979 · S/N 28-7916422 N2921NZephyr Air Corp · Dellwood, MNBuilt 1979 · S/N 32-7940204 N2921QAmbler Aviation LLC · Ambler, PAS/N 32R7780267 N2921RZiegler James F · Darwin, MNBuilt 1969 · S/N 28R-35329 N2921SAirworthy Services LLC · Pompano Beach, FLBuilt 1979 · S/N 32-7940203 N29220Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916423 N29222Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916426 N29227Towne Diana L · Lakeside, CABuilt 1979 · S/N 28-7990438 N2922QWw Aero LLC · Jonesboro, ARS/N 32R-7780268 N2922YBeckstrand John James Wendell · Eagan, MNS/N 28R-8031029 N29230Hawbaker Keith J · Manitou Springs, COS/N 28-8090025 N2923NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 32-7940207 N2923QRegistration Pending · Sandy, UTRegistration pendingS/N 28-7716124 N29247Bas Part Sales LLC · Greeley, COBuilt 1979 · S/N 28R-7931195 N2924MJones Joshua D · Gallatin Gateway, MTBuilt 1977 · S/N 28R-7837105 N2925DFackair LLC · Granville, OHBuilt 1979 · S/N 28-7990558 N2925NClausen Steven L · Hallam, NES/N 28R-7918223 N2925RSpeedbird Aviation Alpha Charlie LLC · Glenn Heights, TXBuilt 1969 · S/N 28R-35330 N29263Aviation Career Enrichment Inc · Atlanta, GABuilt 1979 · S/N 28-7916429 N29265Litchfield Flying Club Inc · Litchfield, MNBuilt 1979 · S/N 28-7990440 N2926JHutchens Wayne G · Atlanta, GABuilt 1979 · S/N 28-7911248 N2926UBedi Kristopher · Fresno, CABuilt 1979 · S/N 28-7911250 N29274Brown Aero Technologies LLC · Alexander City, ALBuilt 1979 · S/N 28-7990442 N2927CMcvey Wesley · Frisco, TXBuilt 1979 · S/N 32-7940211

Back to AD 87-08-08 R3