AD 2016-19-13
Registered aircraft · 960
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-19-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:2016-19-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:2016-19-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:2016-19-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.
N53FJTvpx Ars Inc Trustee · North Salt Lake, UTN53LTVpc Aviation LLC · Valencia, CAN53NJLear 100kz LLC · Burnet, TXN541FBank Of Utah Trustee · Salt Lake City, UTN541ZBank Of Utah Trustee · Salt Lake City, UTN542TPLakeridge Holdings LLC · Portland, ORN544CMFalcon Fawzi III LLC · Fort Lauderdale, FLN54HGFifth Avenue Aviation LLC · Naples, FLN54MHTvpx Msn 390 Business Trust · North Salt Lake, UTN54YPPhifer Inc · Tuscaloosa, ALN54YRPhifer Inc · Tuscaloosa, ALN550SHFalcon 55 LLC · West Bradenton, FLN550THAmc 50 LLC · Wilmington, DEN550WMWno Trust Services LLC Trustee · Wilmington, DEN551ADAci Partners LLC · Ewing Township, NJN552GRGrp Aviation LLC · Van Nuys, CAN553GRRivers Edge Equipment Leasing LLC · Springfield, ILN555CKCarroll Aviation LLC · Wilmington, DEN555GSInvestjet LLC · Miami, FLN555HGShort Hills Aviators LLC · Morristown, NJN555MKNgl Aviation Tul LLC · Tulsa, OKN5567AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN556HDN50hd LLC · Salt Lake City, UTN556KMFifty-One Air LLC · Lampasas, TXN558RCovenanter Investments II LLC · Nashville, TNN55HSRapid Leasing Inc · Cedar Rapids, IAN560USTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN570DWarbler I LLC · Freeland, MIN571CBKba Bridges & Shields LLC · East Point, GAN575JJTm Aircraft Leasing LLC · Wilmington, DEN575TCTroy Equipment Holdings LLC · Houston, TXN577QTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN57KTKlein Tools Inc · Lincolnshire, ILN581STOakwood Books Inc · Charlottesville, VAN584VWilmington Trust Co Trustee · Wilmington, DEN588HPRbg Operations II LLC · Wilmington, DEN58CGCorning Inc · Corning, NYN58HLGreen Button Holdings LLC · Overland Park, KSN58MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN590CLInternational Aviation LLC · Wheeling, ILN595PDirect Ventures Management LLC · Knoxville, TNN598WCWaste Connections US Inc · Houston, TXN599GJLham3 LLC · Plainfield, INN599PCBank Of Utah Trustee · Salt Lake City, UTN59YPNextgen Flying LLC · The Villages, FLN5VJFalconagain Inc · New York, NYN600CNChickasaw Nation · Ada, OKN600JBOgden Aviation LLC · Hinsdale, ILN600JMEast Lake Jet Aviation LLC · Montauk, NYN600LYMajjec Jhett LLC · Springfield, MA
Back to AD 2016-19-13