AD 2016-25-13
Registered aircraft · 1,086
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-25-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-25-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-25-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-25-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.
N911USFlagler County Florida · Bunnell, FLN911WLPlacer County Public Financing Authority · Auburn, CAN911XCMetro Aviation Inc · Shreveport, LAN912KCKern County Sheriffs Office · Bakersfield, CAN913GRS-76 Parts LLC · Blauvelt, NYN913KCKern County Sheriffs Office · Bakersfield, CAN913SMSisters Of Charity Of Leavenworth Health Systems · Grand Junction, CON914GRS-76 Parts LLC · Blauvelt, NYN914SMAir Methods LLC · Greenwood Village, CON916LLMilton S Hershey Medical Center · Hershey, PAN917ZBighorn Holdings LLC · Mccall, IDN919CMPhi Aviation LLC · Tempe, AZN919SFAir Er LLC · Corinth, TXN919SHAirbus Helicopters Inc · Grand Prairie, TXN91AEPerfect Agreements Leasing Inc · Trabuco Canyon, CAN91NSNs Air Leasing LLC · Wilmington, DEN920UAir Methods LLC · Greenwood Village, CON921HMObsidian Aircraft LLC · Boise, IDN921LLMilton S Hershey Medical Center · Hershey, PAN922BFRiverbend Enterprises Inc · Idaho Falls, IDN922RJEnloe Medical Center DBA · Chico, CAN924MMAircraft Trustee Services Inc Owner Trustee · Dover, DEN926CFMontgomery Capital II Of Delaware LLC · Fort Washington, PAN927MDepartment Of Homeland Security · Washington, DCN927MSOnyx Aviation LLC · Needham, MAN929EDepartment Of Homeland Security · Washington, DCN929NPMetro Nashville Police · Nashville, TNN929TXTexas Department Of Public Safety · Austin, TXN930UAir Methods LLC · Greenwood Village, CON934EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN941EMReach Air Medical Services LLC · Santa Rosa, CAN942AEZuni LLC · Kirkland, WAN942EMReach Air Medical Services LLC · Santa Rosa, CAN943AEBoeing Co · Mesa, AZN945DCJs Leasing LLC · Frisco, TXN94ASAmara Sky LLC · Newark, DEN94RPAs350 LLC · Missoula, MTN951RPCity Of Riverside · Riverside, CAN954KHWilmington Trust Co Trustee · Wilmington, DEN955AHBering Air Inc · Nome, AKN95BCCopper River Helicopters LLC · Pleasant Grove, UTN961RAUS Leaseco Inc · Aurora, ORN962RAUS Leaseco Inc · Aurora, ORN969Box Family Aviation LLC · Denver, CON969YCYonkers Contracting Company Inc · Yonkers, NYN96SPGeneral Industries LLC · Camden, NJN970AEPhi Health LLC · Tempe, AZN970WEWest Elk Air LLC · Gunnison, CON971CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN972ACVertical Aviation No 1 LLC · Miami, FL
Back to AD 2016-25-13