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.

N574BFKrusemark Emma A · Pender, NES/N 28-25047 N574DSRich Joseph A · Ashtabula, OHS/N 28R-8018019 N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421 N574MGMinor J Mark · Rockledge, FLBuilt 1979 · S/N 32R-7987101 N574PRSoto Angel L · Las Piedras, PRBuilt 1965 · S/N 32-241 N574TMJohnson Tristan O · Pensacola, FLBuilt 1974 · S/N 32-7540019 N5752URiggin Flight Service · Madison, SDS/N 28-26575 N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056 N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490 N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057 N5754UAuthement Michael Ray · Pecos, TXBuilt 1969 · S/N 28-26577 N5755UKyzer Aviation Holdings LLC · Fort Mill, SCS/N 28-26579 N5755WSchmidt Mia H · Van Nuys, CABuilt 1963 · S/N 28-1499 N5756FStewart Larry E · Seymour, INBuilt 1968 · S/N 28-25059 N5757FWaletzko David L · Avon, MNBuilt 1968 · S/N 28-25060 N5757WN63e LLC · Fallon, NVBuilt 1964 · S/N 28-1527 N5758FTipnis Zachary Arjun · Troy, NYS/N 28-25061 N5759FGelnett Dean A · Lansdale, PABuilt 1968 · S/N 28-25062 N5759WChimera Air Inc · Maumee, OHBuilt 1964 · S/N 28-1529 N575BBZielich Matthew · Glendale, AZBuilt 1975 · S/N 28-7515378 N575BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881958 N575DCArmadillo Aviation LLC · Hummelstown, PABuilt 1979 · S/N 32R-7985105 N575PAGrw Air Services LLC · Springport, INBuilt 1975 · S/N 28-7525330 N575SDBlue Sky Aviation LLC · Menominee, MIBuilt 2023 · S/N 2881633 N576Madera County Aircrafters Inc · Madera, CABuilt 1974 · S/N 28-7425428 N5760FG & D Leasing LLC · Tempe, AZBuilt 1968 · S/N 28-25063 N5761FNoriega Vanessa · Miami, FLBuilt 1968 · S/N 28-25064 N5762UYoung Robert C · Redmond, WABuilt 1969 · S/N 28-26586 N5763FSugarloaf Air LLC · Harrison, ARBuilt 1968 · S/N 28-25066 N5764FRegistration Pending · Monticello, GARegistration pendingS/N 28-25067 N5764USlingsby Scott D Trustee · Francestown, NHBuilt 1970 · S/N 28-26588 N5765FAerotica LLC · Fleming Island, FLBuilt 1968 · S/N 28-25069 N5765UHarvell Joshua L · Salem, WIS/N 28-26589 N5766FDaedalus Flight School Inc · P. FokaiaBuilt 1976 · S/N 28-7725065 N5766WWessels Quin K · Lake Geneva, WIBuilt 1964 · S/N 28-1555 N5767FPena Edwin Arturo · Mission Hills, CABuilt 1968 · S/N 28-25071 N5767UAir Kraft Spraying Inc · Timber Lake, SDBuilt 1969 · S/N 28-26590 N5768FCollum Aviation LLC · Milton, FLBuilt 1968 · S/N 28-25072 N5768UParsons Clinton K DBA · Etna, MEBuilt 1969 · S/N 28-26591 N5769UKim Sungtae · Fort Worth, TXBuilt 1969 · S/N 28-26593 N576FLRocky Top Corp · Erin, TNBuilt 1971 · S/N 28-7125425 N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937 N576PAClear Skies LLC · Whitehall, PABuilt 1975 · S/N 28-7525331 N576WSLottman Transportation LLC · Diller, NEBuilt 2004 · S/N 3255025 N5770WGallo Danny P · Nashotah, WIBuilt 1964 · S/N 28-1578 N5771WCrumpton Bradley N · Caddo Mills, TXBuilt 1964 · S/N 28-1579 N5772UBernstein Matthew D · North Charleston, SCBuilt 1970 · S/N 28-26596 N5772WBallard Gary H · Soddy Daisy, TNBuilt 1964 · S/N 28-1580 N5773UNelson Francis A · Winchester, VABuilt 1970 · S/N 28-26597 N5775UBravo Tango Aviation · Spearfish, SDBuilt 1970 · S/N 28-26599

Back to AD 87-08-08 R3