AD 2017-19-01
Registered aircraft · 187
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:2017-19-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:2017-19-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:2017-19-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:2017-19-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.
N473WBSale Reported · Orlando, FLSale reportedN478XWestwind Helicopters Inc · Santa Fe, TXN495RLSugar Pine Aviation LLC · Merlin, ORN4989Arrow Aviation Company LLC · Broussard, LAN509HHCoulson Aviation (USA) Inc · Portland, ORN5294AArrow Aviation Co LLC · Broussard, LAN5415XConnecticut Air And Space Center · Stratford, CTN547WMBristow LLC · Lake Charles, LAN548GBAviation Instrument Services Inc · Miami, FLN553XBAmerican Express Travel Related Services Co Inc · Newburgh, NYN576AVRegistered aircraftN576DTArea 109 LLC · Brooklyn, NYN576VPN576vp LLC · Chino, CAN60609Turbines Ltd · West Point, NEN6061CTurbines Ltd · West Point, NEN614JCKnight Helo LLC · Wilmington, DEN61DJBlack Badge Aviation LLC · Carson City, NVN644LHBank Of Utah Trustee · Salt Lake City, UTN653LHBank Of Utah Trustee · Salt Lake City, UTN664BCFlow Line Transportation LLC · Dallas, TXN676FXFlexjet Vertical Lift LLC · Stratford, CTN67MECas LLC · Longboat Key, FLN707DSCas LLC · Longboat Key, FLN709PPhi Health LLC · Tempe, AZN709UCArrow Aviation Co LLC · Broussard, LAN711DSPentair LLC · Palmetto, FLN718PPhi Aviation LLC · Lafayette, LAN725MFArrow Aviation Company LLC · Broussard, LAN725PPhi Aviation LLC · Lafayette, LAN7266KGulf Helicopters LLC · Santa Fe, TXN72EHHelinet Aviation Services LLC · Van Nuys, CAN745PPhi Aviation LLC · Lafayette, LAN751LLState Of Illinois · Springfield, ILN753PPhi Health LLC · Tempe, AZN754LArrow Aviation Co LLC · Broussard, LAN759PPhi Health LLC · Tempe, AZN760AFArkansas Childrens Hospital · Little Rock, ARN760BGBristow U S LLC · New Iberia, LAN760GPIndustrial Integrity Solutions LLC · Ontario, CAN760JEIslander Holdings Ltd · Fort Lauderdale, FLN760PVSikorsky Aircraft Corp · Stratford, CTN761AFArkansas Childrens Hospital · Little Rock, ARN761CGCoulson Aviation (USA) Inc · Portland, ORN761DSikorsky Aircraft Corp · Stratford, CTN761MHMansfield Heliflight Inc · Milton, VTN761NYNew York State Police · Latham, NYN762DSikorsky Aircraft Corp · Stratford, CTN762MHGm Leasing Co LLC · Broussard, LAN7633MSikorsky Aircraft Corp · Stratford, CTN7634YSikorsky Aircraft Corp · Stratford, CT
Back to AD 2017-19-01