Skip to content

Registered aircraft · 22,416

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.

N6697JGlenn Larry W · Bunn, NCBuilt 1968 · S/N 28-24390 N6699JRegistration Pending · Loup City, NERegistration pendingBuilt 1968 · S/N 28-24393 N669CRIrizarry Betsy M · Mayaguez, PRBuilt 1966 · S/N 32-349 N669DLDana Ihab A · Dalton, PAS/N 3257148 N669GBBernardi Gary R · New Cumberland, PABuilt 1982 · S/N 28-8211031 N66BHLj Air LLC · Ada, MIBuilt 1979 · S/N 32-7940067 N66CSWolf Steven T · De Graff, OHBuilt 1973 · S/N 28R7335107 N66GNMoye Brian C · Naples, FLBuilt 1969 · S/N 28-5717 N66JJWilliams Nicholas Indrais · Pickerington, OHBuilt 1972 · S/N 28R-7235157 N66LBHermeling Mark A · Vail, AZBuilt 1973 · S/N 28-7310110 N66LGHarpenden Corp · Los Angeles, CABuilt 2011 · S/N 2843696 N66MSInternational Air Services Inc Trustee · Carson City, NVS/N 28R8431021 N66WMTriple R & B Aviation LLC · Miami Beach, FLBuilt 1966 · S/N 32-40002 N6700FRunels Thomas L · Battle Creek, MIBuilt 1976 · S/N 28-7790161 N6701JJones Bob J Trustee · Littleton, COBuilt 1968 · S/N 28-24395 N6702JWaldron Michelle M · Saranac, NYBuilt 1968 · S/N 28-24397 N6705JDuncan William E · Troy, IDBuilt 1968 · S/N 28-24400 N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035 N670LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881680 N670MPStar Ground Services Inc · Tinian, MPBuilt 1971 · S/N 32-7140021 N670PWN670pw LLC · Monmouth Beach, NJBuilt 1981 · S/N 32R-8213010 N670SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881436 N670UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020168 N670XBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 2844055 N6711JFirecrest LLC · Holly Springs, MSBuilt 1968 · S/N 28-24408 N6711WBrinkman Michael R · Cleveland, TNBuilt 1965 · S/N 28-20824 N6712JF & F Flying Service Inc · Springfield, VAS/N 28-24410 N6714WFriend Henry H · Hibbs, PABuilt 1965 · S/N 28-20827 N6716WSan Diego Community College District · San Diego, CABuilt 1965 · S/N 28-20829 N6717WFieri Douglas J · La Verne, CABuilt 1965 · S/N 28-20830 N67180French Chris E Jr · Concord, NCBuilt 1965 · S/N 32-121 N6718JWandro Nicholas John · Norman, OKBuilt 1968 · S/N 28-24420 N6718WMorris Mark · Floral City, FLBuilt 1965 · S/N 28-20831 N6719WPennington Carey L · Tacoma, WABuilt 1965 · S/N 28-20832 N671CMElite Air Solutions LLC · Decatur, GABuilt 1974 · S/N 28R-7435250 N671CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2843868 N671LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881681 N671SCSpartan Eduction LLC · Tulsa, OKBuilt 2021 · S/N 2881437 N6720JRgi Industry Inc DBA · Norman, OKBuilt 1968 · S/N 28-24424 N6721JLeduc Marquez Ramon · Santa Isabel, PRBuilt 1968 · S/N 28-24425 N6722JPlanenutz LLC · Deland, FLS/N 28-24427 N6722WTurnquest Alexis · West Valley City, UTS/N 28-20836 N6723WWignall Brett T · Jasper, TXBuilt 1965 · S/N 28-20837 N6724JDisabato Anthony · Chicago, ILBuilt 1968 · S/N 28-24430 N6724WHughes Jeffrey A · Wrightsville Beach, NCBuilt 1965 · S/N 28-20838 N6725JBrookeridge Eagles LLC · Downers Grove, ILS/N 28-24432 N6727JS&S Piper · Tipton, CAS/N 28-24435 N6727WCherokee Aviation LLC · Kalispell, MTBuilt 1965 · S/N 28-20842 N6728WFifteen Hundred Hours LLC · Broken Arrow, OKBuilt 1965 · S/N 28-20843 N672CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2843869

Back to AD 87-08-08 R3