AD 2010-26-05 R1
Registered aircraft · 1,068
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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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.
N558RCovenanter 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, FLN5CAMach 87 LLC · Sulphur Springs, TXN5VJFalconagain Inc · New York, NYN600CDKalitta Charters LLC · Ypsilanti, MIN600CNChickasaw Nation · Ada, OKN600JBOgden Aviation LLC · Hinsdale, ILN600JMEast Lake Jet Aviation LLC · Montauk, NYN600LYMajjec Jhett LLC · Springfield, MAN600RARoyal Air Freight Inc · Waterford, MIN601GS1 Trophy Husband LLC · Omaha, NEN603CNChickasaw Nation · Ada, OKN603GJRegistered aircraftN604PTR3hd Air LLC · Marietta, GAN606AMSl Jet LLC · Cleveland, TNN609CQFalki LLC · Winter Springs, FLN609GJBank Of Utah Trustee · Salt Lake City, UTN610GJDirect Ventures Management LLC · Knoxville, TNN610RLFalconrl LLC · Missoula, MTN611EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN611TXMegaequipment LLC · Wilmington, NCN613BDLynx Medical Transport LLC · Cincinnati, OHN613BHBoz Holdings LLC · St Thomas, VIN613CSAvlease Company LLC · Ann Arbor, MIN615FJMegatel Group Services LLC · Dallas, TXN615MSMss Falcon 900 LLC · Denver, CON617DVCae III Ltd · Wilmington, DEN618GHDodson International Parts Inc · Rantoul, KSN61JEJce Leasing LLC · Little Rock, ARN620DXAdams Aviation Services Inc Trustee · Wilmington, DEN621HDXls Aviation LLC · Effingham, IL
Back to AD 2010-26-05 R1