AD 2002-15-08
Registered aircraft · 1,064
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:2002-15-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-15-08')
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:2002-15-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-15-08') 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.
N155RBAerospace Trust Management LLC Trustee · Wilmington, DEN155RDCastro Be LLC · Miami, FLN157AEBoeing Company · Mesa, AZN1603MCity Of San Antonio Texas · San Antonio, TXN162GRReach Air Medical Services LLC · Lewisville, TXN162TMSaberair LLC · Englewood, CON167MTAnalar Corp · Princeton, NJN168BHBhi Holdings #1 LLC · Ontario, ORN16NSNs Air Leasing LLC · Wilmington, DEN172AEUS Department Of Homeland Security · Washington, DCN173BHBhh Leasing #4 LLC · Pensacola, FLN174AHAres Air LLC · Phoenix, AZN175AEMainstream Investment LLC · Tavernier, FLN175SCSeminole County Sheriffs Office · Sanford, FLN176MTDr Heli Acquistion LLC · Princeton, NJN176SCSeminole County Sheriffs Office · Sanford, FLN178MTTribeca Heli LLC · Princeton, NJN179AAirbus Helicopters Inc · Grand Prairie, TXN179MTAnalar Corp · Princeton, NJN17KBTrevor Corp · Grayslake, ILN180QDepartment Of Homeland Security · Washington, DCN1811FMaster Link Corp · Barceloneta, PRN181PLAlpine Air Alaska LLC · Girdwood, AKN183AEU S Dept Of Homeland Security · Washington, DCN183EHBristow LLC · Lake Charles, LAN183SDOrange County Sheriff'S Department · Costa Mesa, CAN184RDepartment Of Homeland Security · Washington, DCN184SDCounty Of Orange - Air Support · Costa Mesa, CAN185SDOrange County Sheriff'S Department · Costa Mesa, CAN186AEUS Department Of Homeland Security · Washington, DCN187AEUS Department Of Homeland Security · Washington, DCN188EULashinski Robert D Trustee · Sebastopol, CAN191NRMaryland Natural Resources Police · Stevensville, MDN191TXTexas Dept Of Public Safety · Austin, TXN192ADepartment Of Homeland Security · Washington, DCN193BHBlack Mountain Aviation LLC · Boulder City, NVN194AETemsco Helicopters Inc · Ketchikan, AKN1964LDepartment Of Homeland Security · Washington, DCN1977GDepartment Of Homeland Security · Washington, DCN197BHNevada Helicopter Leasing LLC · Greenwood Village, CON198AETemsco Helicopters Inc · Ketchikan, AKN1997GAirbus Helicopters Inc · Grand Prairie, TXN1CRComanche Maverick Air LLC · Houston, TXN1MZA Star 350 LLC · Henderson, NVN1SDPinellas County Sheriffs Office · Clearwater, FLN202PBCalpass Corp · Del Mar, CAN202SCNs Air Leasing LLC · Wilmington, DEN203CHCoastal Helicopters Inc · Juneau, AKN203ZDepartment Of Homeland Security · Washington, DCN204CHCoastal Helicopters · Juneau, AK
Back to AD 2002-15-08