AD 2012-12-20
Registered aircraft · 99
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:2012-12-20')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-12-20')
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:2012-12-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-12-20') 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.
N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJN6UXHelicopters Inc · Cahokia, ILN709PPhi Health LLC · Tempe, AZN718PPhi Aviation LLC · Lafayette, LAN724PHPhi Aviation LLC · Lafayette, LAN725LLMilton S Hershey Medical Center · Hershey, PAN725PPhi Aviation LLC · Lafayette, LAN72EHHelinet Aviation Services LLC · Van Nuys, CAN745PPhi Aviation LLC · Lafayette, LAN753PPhi Health LLC · Tempe, AZN754LArrow Aviation Co LLC · Broussard, LAN759MMTrevor Corp DBA · Grayslake, ILN759PPhi Health LLC · Tempe, AZN764AMNorth Flight Aero Med · Grand Rapids, MIN768AMSpectrum Health Hospitals · Grand Rapids, MIN769PPhi Aviation LLC · Lafayette, LAN76HHHallecopter LLC · Wilmington, DEN76ZAN76za LLC · New York, NYN772PPhi Aviation LLC · Lafayette, LAN773BGBristow LLC · Lake Charles, LAN781PPhi Health LLC · Tempe, AZFirst renewal noticeN781RLGm Leasing Company LLC · Broussard, LAN782RLGm Leasing Company LLC · Broussard, LAN783RLGm Leasing Company LLC · Broussard, LAN784RLGm Leasing Company LLC · Broussard, LAN785PSale Reported · Robert, LASale reported, canceledN785RLGm Leasing Company LLC · Broussard, LAN786RLGm Leasing Company LLC · Broussard, LAN787RLGm Leasing Company LLC · Broussard, LAN794PPhi Aviation LLC · Lafayette, LAN797PPhi Health LLC · Tempe, AZN798PPhi Health LLC · Tempe, AZN804PAPathfinder Leasing LLC · Anchorage, AKN821SSFly Safe LLC · Wilmington, DEN849PBArrow Aviation Co LLC · Broussard, LAN883ALBristow US LLC · New Iberia, LAN891BGGm Leasing Co LLC · Broussard, LAN893BGBristow U S LLC · New Iberia, LAN896BGBristow U.S. LLC · New Iberia, LAN905RDBristow LLC · Lake Charles, LAN90DKDekalb County Police · Tucker, GAN916LLMilton S Hershey Medical Center · Hershey, PAN919CMPhi Aviation LLC · Tempe, AZN919SFAir Er LLC · Corinth, TXN921LLMilton S Hershey Medical Center · Hershey, PAN945DCJs Leasing LLC · Frisco, TXN970AEPhi Health LLC · Tempe, AZN979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN99523Ns Air Leasing LLC · Wilmington, DE
Back to AD 2012-12-20