Registered aircraft · 1,827

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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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:90-06-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
  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:90-06-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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.

N1163MNew World Aviation LLC · Edinburg, TXBuilt 1988 · S/N 550-0568 N116KCRa Aviation LLC · Dover, DEBuilt 1980 · S/N 550-0149 N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081 N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007 N118MMBradley Flight LLC · Denver, COFirst renewal noticeBuilt 1999 · S/N 650-7105 N118RWCitation N118rk LLC · Houston, TXS/N 560-0389 N119LCBravo 969 LLC · Mayo, FLBuilt 2001 · S/N 550-0969 N1200NCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0681 N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078 N121CNScl Family Sr-22 LLC · San Antonio, TXBuilt 2001 · S/N 550-1000 N121HLAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0121 N121KMWings By Dkw LLC · Lake Charles, LABuilt 1981 · S/N 550-0273 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N121MJIal Corp · Lewes, DEBuilt 1984 · S/N 550-0489 N122NBSunfair Commercial Leasing Inc · Yakima, WABuilt 1998 · S/N 550-0836 N123FFN123ff LLC · North Palm Beach, FLS/N S550-0005 N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124 N1249PTrns Solutions LLC · Lewes, DEBuilt 1982 · S/N 550-0451 N124CMSolomon Mark Trustee · Wilmington, DEBuilt 1984 · S/N FA-24 N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124PMMc Air LLC · Mobile, ALBuilt 2004 · S/N 550-1090 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 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 N125BAAlpine Aviation Inc · Provo, UTS/N UB-6 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N125RGAero South Florida Corp · West Palm Beach, FLBuilt 1981 · S/N 550-0248 N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N126TFFox Lumber Sales Inc · Hamilton, MTBuilt 1997 · S/N 550-0815 N127BAAlpine Aviation Inc · Provo, UTS/N UB-7 N127CLWyoming Aviation LLC · Sheridan, WYBuilt 1978 · S/N 550-0007 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127JMN127jm LLC · Clovis, NMBuilt 1981 · S/N 550-0253 N127RGKlsit US Holdings LLC · Williams Bay, WIBuilt 2000 · S/N 550-0917 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N127ZAMagic Carpet LLC · Wilmington, DEBuilt 2002 · S/N 550-1032 N129GBCapital Cost Corp · Wilmington, DEFirst renewal noticeBuilt 1983 · S/N 650-0006 N129LTTnl Management LLC · Cullman, ALBuilt 1997 · S/N 550-0821 N129PBSmaf Environmental LLC · Prineville, ORBuilt 2001 · S/N 550-0973 N129RPN129rp LLC · Tulsa, OKBuilt 2000 · S/N 550-0928 N12JEProfessional Pilot Training Inc · Eagle Lake, TXBuilt 1980 · S/N 550-0185 N12LDSouth Georgia Motor Sports LLC · Wilmington, DEFirst renewal noticeS/N 560-0527 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N13092Nxt LLC · Oklahoma City, OKBuilt 2006 · S/N 560-0707 N131PGAga Aviation LLC · Lewes, DEBuilt 1986 · S/N 650-0126 N131RRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 560-0366

Back to AD 90-06-13