Registered aircraft · 600

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-10-01') 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-10-01') 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-10-01')
    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-10-01')
  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-10-01')
  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-10-01')
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.

N100DSCascade Peaks Aviation LLC · Springfield, ORBuilt 1990 · S/N 550-0639 N100GG1mk Leasing LLC · Lindale, TXBuilt 1977 · S/N 501-0020 N101RRSky High Aviation LLC · Chino, CABuilt 1982 · S/N 5010241 N102DRCloud 9 LLC · Lafayette, LABuilt 1982 · S/N 551-0436 N102HBBuzz-Air Of Indiana Inc · Michigan City, INBuilt 1982 · S/N 550-0409 N103HCEstar Aerospace Corp · Columbus, OHS/N A068 S.A.N106SRSafari Intl LLC · Lewes, DEBuilt 1982 · S/N 550-0346 N107EEBlandco LLC · Greenville, SCBuilt 1991 · S/N 5500667 N109GAFinancial Mistake Air LLC · Uvalda, GABuilt 1980 · S/N 550-0124 N109JCL&F Aviation LLC · Dallas, TXBuilt 1979 · S/N 550-0099 N10EGJarcav LLC · The Woodlands, TXBuilt 1979 · S/N 550-0055 N10LYAir & Water Research Corp · Wilmington, DEBuilt 1983 · S/N 550-0466 N10TCGardner Aviation LLC · Hot Springs, ARBuilt 1984 · S/N 550-0495 N110JBIngles Markets Inc · Asheville, NCBuilt 1981 · S/N 501-0172 N111AFWings Aloft Inc · Portland, ORBuilt 1981 · S/N 550-0256 N111BBCypress Aircraft Sales LLC · Clermont, FLBuilt 1975 · S/N 500-0248 N111GJMalik Hassan · Richfield, OHBuilt 1980 · S/N 5510187 N111LJSourek Trail Co Inc · Barberton, OHBuilt 1982 · S/N 550-0350 N111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLBuilt 1980 · S/N 550-0196 N113CATeton West Holdings LLC · Rcho Sta Marg, CABuilt 1982 · S/N 501-0148 N1163MNew World Aviation LLC · Edinburg, TXBuilt 1988 · S/N 550-0568 N116KCRa Aviation LLC · Dover, DEBuilt 1980 · S/N 550-0149 N117MAT&J Aviation LLC · Clovis, NMBuilt 1979 · S/N 501-0249 N1200NCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0681 N121HLAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0121 N121KMWings By Dkw LLC · Lake Charles, LABuilt 1981 · S/N 550-0273 N121MJIal Corp · Lewes, DEBuilt 1984 · S/N 550-0489 N123KDAircraft Resource Center Inc · Lakeville, MNBuilt 1981 · S/N 501-0195 N123PL4-S Aviation LLC · Clovis, NMBuilt 1982 · S/N 501-0234 N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124 N1249PTrns Solutions LLC · Lewes, DEBuilt 1982 · S/N 550-0451 N1250VAquila Air LLC · Cincinnati, OHS/N 550-0439 N1252DAeroelite Aviation LLC · Columbia, MOBuilt 1983 · S/N 551-0476 N12549Surdex Corp · Chesterfield, MOS/N 550-0501 N1255KCypress Aircraft Sales LLC · Clermont, FLS/N 550-0505 N125RGAero South Florida Corp · West Palm Beach, FLBuilt 1981 · S/N 550-0248 N127CLWyoming Aviation LLC · Sheridan, WYBuilt 1978 · S/N 550-0007 N127JMN127jm LLC · Clovis, NMBuilt 1981 · S/N 550-0253 N12CVQuartermaster Growth LLC · Vashon, WAS/N 501-0081 N12JEProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1980 · S/N 550-0185 N12VBCruce Aircraft Services LLC · Coral Gables, FLBuilt 1978 · S/N 501-0078 N12WHAieleron Air LLC · Wilmington, DEBuilt 1977 · S/N 501-0064 N133SCValiar Limited Company Trustee · Casper, WYBuilt 1979 · S/N 5010131 N138SAMamia Motor Sports Inc · Waller, TXBuilt 1973 · S/N 500-0138 N13DLDlm Holding Group LLC · Stevensville, MIBuilt 1978 · S/N 501-0052 N13KDWoelbing Aviation LLC · Franksville, WIBuilt 1979 · S/N 501-0119 N13STN7880l LLC · Port Charlotte, FLBuilt 1978 · S/N 501-0285 N14RM29foxtrot LLC · Wilmington, DEBuilt 1980 · S/N 551-0169 N14VAAerospace Asset Holdings LLC · Wilmington, DEBuilt 1979 · S/N 501-0137 N150RMBurke Aviation LLC · Toomsuba, MSBuilt 1978 · S/N 501-0076

Back to AD 87-10-01