Registered aircraft · 132

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

N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067 N47HWCelebration Tv America Inc · Houston, TXS/N 258023 N509DMTeam Aero LLC · Shawnee, KSS/N 258056 N511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 259031 N515LRAviation Dynamics LLC · South Portland, MEBuilt 1998 · S/N NA1006 N518RRMidas Air Corp · Wilmington, DES/N NA0278 N520LR1489 LLC · New York, NYBuilt 1992 · S/N NA1008 N520SBBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259032 N524LRUsac Airways 693 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 259-024 N52SMWumac Inc · South Portland, MES/N NA1009 N533LRAviation Dynamics LLC · South Portland, MEBuilt 1992 · S/N 259033 N541LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259041 N561PSTlc Aviation LLC · Bloomfield Hills, MIBuilt 1980 · S/N NA-0262 N564BRKaleidoscope Charter Services Corp · Kansas City, MOS/N NA0287 N567CLN567cl LLC · Dallas, TXBuilt 1993 · S/N 259035 N58BLHawker 800xp LLC · Fort Lauderdale, FLS/N 258236 N591CFKmw Flight LLC · Wilmington, DEBuilt 1989 · S/N 258175 N600MVN767cj LLC · Williamsburg, VABuilt 1993 · S/N 259036 N606Sale Reported · La LagunitaSale reportedBuilt 1987 · S/N 258068 N609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1984 · S/N 258019 N616WGForza Wings LLC · Laredo, TXBuilt 1985 · S/N 258030 N6200HTnr Aircraft Holdings LLC · Englewood, COBuilt 1987 · S/N 258087 N624MPLansing Community College · Mason, MIBuilt 1970 · S/N NA-756 N65DLChestnut Northern Partners LLC · Farmington Hills, MIBuilt 1993 · S/N 258224 N664SCAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 258032 N671MMKmwflight LLC · Wilmington, DEBuilt 1984 · S/N 258014 N671RRAircraft Fidelity Corp Trustee · Dover, DEBuilt 1993 · S/N 258244 N67WESkyview LLC · Wilmington, DEBuilt 1993 · S/N 259038 N682DN682d LLC · Wilmington, DES/N NA0431 N68ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 258234 N700RRDaxen Logistic LLC · Chino, CABuilt 1978 · S/N NA-0217 N704FUK&A Advisors LLC Trustee · Wilmington, DES/N NA0335 N707HDEfs Aircraft Leasing LLC · North Highlands, CABuilt 1994 · S/N 259016 N717MTAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1989 · S/N 258163 N718HCAcme Leasing II LLC · Nashville, TNBuilt 1985 · S/N 258040 N718LFJet Geeks Aviation Maintenance Inc · Teterboro, NJS/N 258254 N724GPJawad A Shah Md Pc · Flint, MIS/N 258238 N728HHNevarez Julio · Brownsville, TXS/N 258166 N730CJN730cj LLC · Williamsburg, VABuilt 1992 · S/N NA1007 N732AADjcj LLC · Nashville, TNBuilt 1993 · S/N 258243 N7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N NA 0320 N770RGAir Mccormack LLC · Chicago, ILBuilt 1993 · S/N 259025 N777EHMilligan Michael Zachery · Reno, NVS/N 257020 N778RMAero Advantage Services Corp Trustee · Wilmington, DES/N 258178 N798PAJli Holdings Group Inc · Johns Island, SCS/N 258070 N800AFJec Hawker LLC · Pflugerville, TXS/N 258158 N800CJCdmr Pj LLC · Jackson, NJS/N 258081 N800EGAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 258182 N800FJAstra Aircraft Holdings Corp · Wilmington, DES/N NA0428 N800JMGreen Chair Productions Inc · Wichita Falls, TXS/N NA0421

Back to AD 89-18-07 R1