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.

N5398FFlight Leasing Corp · Wilmington, DES/N 28-7790108 N5398LWarrell Althea M · Haines City, FLS/N 28-4707 N5398WTrussell Robert Eugene Jr · Covington, TXS/N 28-466 N53995Wilshire & Catalina LLC · Austin, TXBuilt 1979 · S/N 28R-7918258 N5399FHaueisen Jessica M · Franklin, GAS/N 28-7790109 N5399LWinters Charles B · Farmington, NMBuilt 1968 · S/N 28-4708 N5399TParke Jonathan · Durham, NCBuilt 1972 · S/N 28R-7235231 N539JBPrince Bruce Alan · Thomasville, NCBuilt 1979 · S/N 32-7940198 N539MFKovarik Kevin · Fort Atkinson, IABuilt 1972 · S/N 28-7305064 N539TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020239 N53FSBlue Sky Flyers Inc · Greeley, COBuilt 1981 · S/N 28-8290026 N53JLRegistered aircraftBuilt 1977 · S/N 32R-7780484 N53JSC-140 Company LLC · Milton, FLBuilt 1968 · S/N 28R-30840 N53KCDm Asset Management LLC · Plain City, OHBuilt 1978 · S/N 28-7990032 N53LALandis Aviation Inc · Valdosta, GABuilt 1972 · S/N 28-7310066 N5400WGuches Jim D · Caldwell, IDBuilt 1962 · S/N 28-468 N5401WWegner Eric E · Oconomowoc, WIBuilt 1962 · S/N 28-469 N5402FMorgan Kristopher Lm · Crowley, TXBuilt 1976 · S/N 28-7725054 N5402SCharlie Ten Inc · Quakertown, PABuilt 1971 · S/N 28-7105139 N5403FAcs Wings LLC · Deerfield Beach, FLBuilt 1976 · S/N 28-7725055 N5406WScott Jeffrey E · Connersville, INBuilt 1962 · S/N 28-475 N5407FFly Quest Aviation LLC · La Verne, CABuilt 1977 · S/N 28-7790112 N5407WThird Step 6 LLC · Gilbert, AZBuilt 1962 · S/N 28-476 N5409FBlackwolfden Aviation LLC · Belgrade, MTS/N 28-7790114 N540AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 28R8431025 N540CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881049 N540FLGregory James A · East Burke, VTBuilt 1971 · S/N 28-7125372 N540PULeo S Anton · Aliso Viejo, CABuilt 2003 · S/N 2844096 N540UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020164 N540WBAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 2002 · S/N 3257269 N54100Pilot Aeromedical Consulting Services LLC · Freeland, MIS/N 32-7300040 N5411FMack Robert A · Brighton, COBuilt 1976 · S/N 32R-7780003 N5415FYork Brandon K · Spring, TXBuilt 1976 · S/N 28-7715128 N5415S98x LLC · Caddo Mills, TXBuilt 1970 · S/N 28-7125113 N5416SNelson Stephen A · Milaca, MNBuilt 1971 · S/N 28-7125114 N5417FStarnes Robert D · Lavonia, GABuilt 1976 · S/N 28-7715130 N5417SHiga Bertram T · Northridge, CARegistration expired, pending cancellationBuilt 1971 · S/N 28-7125116 N5417WCrystal Lake Air LLC · Lake Geneva, FLS/N 28-488 N5419FJfl Aviation LLC · Big Rock, ILBuilt 1976 · S/N 28-7790117 N5419SAberdeen School District · Aberdeen, MSBuilt 1971 · S/N 28-7125117 N541BPEdge Aircraft LLC · Denver, COBuilt 1999 · S/N 3257087 N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089 N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050 N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335 N541MVHujatullah Bayat · West Linn, ORS/N 32R-7985080 N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097 N541RJSwostar Holdings LLC · Brookhaven, GABuilt 1978 · S/N 28-7911087 N541SPRed Baron Rentals LLC · Jacksonville, FLS/N 28-7415570 N541VBCartier John · Cumberland, RIBuilt 2003 · S/N 3257334 N5420WGade Donald A · Antioch, ILS/N 28-491

Back to AD 87-08-08 R3