Registered aircraft · 1,770

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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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.

N425WFRegistered aircraftAssigned, pending cancellationS/N 4250207 N425WGR Ritchie Lp · Odessa, TXBuilt 1981 · S/N 425-0030 N425WLAirmann LLC · Mount Sterling, KYBuilt 1984 · S/N 4250197 N425WTIrwin International Inc · Corona, CAS/N 425-0175 N425XR B Stevenson Aviation LLC · Chandler, AZBuilt 1982 · S/N 425-0122 N425XPK&M Aviation LLC · Aberdeen, SDBuilt 1981 · S/N 425-0064 N425YAriel Leasing LLC · Aberdeen, SDBuilt 1984 · S/N 425-0209 N426LJVenture Air Solutions Inc · Opa Locka, FLBuilt 1981 · S/N 402C0434 N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N427CCBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 1977 · S/N 421C0348 N427JMPittman James L · Destin, FLS/N 421C0103 N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251 N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243 N42AAN42aa LLC · Nantucket, MABuilt 1979 · S/N 402C0238 N42AWWilliams C Allen · Longview, TXBuilt 1981 · S/N 425-0136 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42HMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 421C0683 N42MGSouth Aero Inc · Albuquerque, NMS/N 402C0320 N42MLRegistered aircraftS/N 421C0639 N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42SGPolar Star Co · Wilmington, DES/N 4140927 N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385 N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431 N435CEPacific Fbo Properties LLC · Santa Barbara, CABuilt 1981 · S/N 425-0042 N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274 N43AWWilliams C Allen · Longview, TXBuilt 1985 · S/N 425-0225 N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224 N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016 N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401 N440JBAg Tech Farm Services · Gamaliel, KYBuilt 1975 · S/N 421B0858 N440LJByington William · Minden, NVS/N 421C0299 N441CRJmsanzotta Inc · Littleton, COS/N 425-0149 N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057 N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441 N4420F7172 Records LLC · Eagle Pass, TXBuilt 1981 · S/N 425-0053 N442CCRaymond Andrew A · Crescent, IAS/N 414A0483 N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303 N443HFernweh Aviation LLC · Bandon, ORBuilt 1980 · S/N 425-0002 N443RSalinas Construction Technologies Ltd · Pleasanton, TXS/N 414-0361 N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567 N444ATCore Aviation LLC · Dayton, OHS/N 421B0897 N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893 N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490 N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522 N444FABank Of Utah Trustee · Salt Lake City, UTS/N 414-0549 N444HDChado Richard P II · Rancho Cucamonga, CAS/N 421C0480 N444JVTwinair LLC · Junction City, WIBuilt 1981 · S/N 425-0070

Back to AD 2018-03-03 R1