Skip to content

Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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.

N6700CKelly Aviation & Investigation LLC · Vail, AZBuilt 1980 · S/N ME-275 N6701Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30187 N6701RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1980 · S/N ME-281 N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285 N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297 N6702Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30188 N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287 N6703DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30234 N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325 N6704ZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30396 N6705YDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30397 N6706QDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30422 N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299 N6707ADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30395 N6707MLouis & Clark Aviation LLC · Fort Myers, FLBuilt 1979 · S/N WA-48 N6708DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30480 N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53 N6709Delta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30481 N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56 N670AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25335 N670DNDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25331 N670FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 777 N670NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7106 N670UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29240 N6710EDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30482 N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311 N6711MDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30483 N6711RAme Flight Holdings LLC · Oasis, IDBuilt 1979 · S/N WA-60 N6712AMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N ME-312 N6712BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30484 N67134United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29283 N6713VMclendon Donnie E · Winder, GABuilt 1979 · S/N WA-61 N6713YDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30777 N6714QDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30485 N6715CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30486 N6715VByrds Wholesale Inc · Clayton, NCS/N WA-70 N6715YTrevitue LLC · Dripping Springs, TXS/N WA-65 N67169Arai Eisuke · San Jose, CABuilt 1979 · S/N WA-67 N6716CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30838 N6716SShelby Monroe Group LLC · Sioux City, IABuilt 1979 · S/N WA-71 N6716ZNextgen Flight Academy Inc · Riverside, CABuilt 1980 · S/N ME-328 N67171Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30839 N6718RVernier Deborah J · Goshen, KYBuilt 1980 · S/N WA-76 N6719VDaniel Scott · Kingston, GABuilt 1980 · S/N WA-81 N671FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 778 N671LLCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1966 · S/N LJ-148 N671NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7246 N671UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30026 N67201Sale Reported · Sunman, INSale reportedBuilt 1980 · S/N WA-111 N6720TScandinavian Aviation Academy Inc · El Cajon, CABuilt 1980 · S/N ME-335

Back to AD 95-26-15 R1