AD 2016-20-06
Registered aircraft · 453
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
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:2016-20-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-06')
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:2016-20-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-20-06') 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.
N327TLThomas H Lee Capital LLC · Teterboro, NJN329GAGulfstream Aerospace Corp · Savannah, GAN32JEKenmore Crew Leasing Inc Trustee · Bellingham, WAN32MJAviation Company Inc · Cheyenne, WYN330RWWest2east 330 LLC · Seattle, WAN332GAGulfstream Aerospace Corp · Savannah, GAN333ECFlying Falcon Inc · Frenchmans Bay Qtr, VIN333FGFg Aviation LLC · Philadelphia, PAN337LRJetsteam Aviation Inc · Cheyenne, WYN338MMRegistered aircraftN344AAAbsolutamente LLC · Windsor, CAN348DJMecha Holdings LLC · Newtown Square, PAN352BHGle 1393 LLC · Sunny Isles, FLN352DJDelawair LLC · Newark, DEN352FT352 Corp · Conshohocken, PAN356BRBdp Airways LLC · Dover, DEN358CYBondio LLC · Great Neck, NYN360HVTk Leasing LLC · Honolulu, HIN365KVKamboj Aviation Group Inc · Modesto, CAN36DZSmb Giii LLC · Longwood, FLN36JEButterfield Holdings LLC · Oklahoma City, OKN36PNB&G Leasing LLC · Wilmington, DEN370RSHumble Travel LLC · Wilmington, DEN371FPWing Aviation Group LLC · Wilmington, DEN37ECPark Ohio Industries Inc · Cleveland, OHN37WHNorthrop Grumman Systems Corp · El Segundo, CAN383DJGiv Investors LLC · Olean, NYN388CAPhoenix Aurora LLC · San Juan, PRN388MMAc Travel LLC · Palm Beach, FLN394AJGlf4 1470 LLC · Wilmington, DEN396NSAviation Sales Associates LLC · Costa Mesa, CAN397JJAvion LLC · Birmingham, ALN39AVBlackbird Jet LLC · Boca Raton, FLN3DPAircraft Holding Solutions LLC · Newark, DEN400AJMilberg Falcon Express LLC · Knoxville, TNN400FJPtj Associates LLC · South Pasadena, CAN400JZJrb Pelican Point Investments LLC · Pompano Beach, FLN400SFGlobal Aero Aviation Inc · Houston, TXN400ZUEastern Stearman Inc Trustee · Leesburg, VAN401JSMm Fleet Holdings LLC · Farmers Branch, TXN403JSPistola Alta LLC · Miami, FLN403SBSmb G-IV X LLC · Longwood, FLN403TB403tb LLC · Dover, DEN404AAPacific Rim Management LLC · Downey, CAN408JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN40VCFuerza Regida Corp · San Bernardino, CAN411LTKent Aviation LLC · Midland, TXN411YMRida Realty Investments Corp · Houston, TXN412JDNormandy'S Triumph LLC · Tampa, FLN413WJN492a LLC · Goodyear, AZ
Back to AD 2016-20-06