AD 2012-17-06
Registered aircraft · 2,157
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-17-06')
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-17-06')
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-17-06') 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-17-06') 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.
N5582PPierce Stephen C · O Fallon, MON5584PPinnell Roger D · Shell Knob, MON5585PBas Part Sales LLC · Greeley, CON5588PNorth Town Comanche LLC · North Las Vegas, NVN5589PEggers Cindy S · Winnemucca, NVN558PCSammons Aero Services LLC · Edgewood, TXN5590PUdall Thomas H · Mckinney, TXN5592PWelch Roy T · Garfield, WAN5593PDingus Donald E Jr · Brownfield, TXN55CYBonneville Aero Works LLC · Greenville, SCN5600PBfi Inspections LLC · Nevada City, CAN5601PDevil Dusters Inc · Artesia, NMN5603PLitteken David T · Aviston, ILN5611PWeyland Aviation Inc · Lewes, DEN5612PClarity Aviation LLC · Boise, IDN5614PShetty Balakrishna · Wesley Chapel, FLN5616PKallenberger Ross A · Bakersfield, CAN5617PBuchheit Dirk · Lake Worth, FLN5622PBaker Franklin E · Montgomery, ILN5624PCobb Jeremiah B · Colorado Springs, CON5628PMiller Space A · Simi Valley, CAN5629PVick Josh K · Brentwood, TNN5630PWick Eric J · Three Lakes, WIN5631PNeal Brian C · Monrovia, CAN5634PWaters George A · Oklahoma City, OKN5637PSellman Richard · Chadron, NEN5643PRed Cardinal Aviation LLC · Chantilly, VAN5645PDeines E Jay · Wa Keeney, KSN5651PSeremet Cristina L · Beaver Dam, WIN5653PBeasley Charles R · Lumberton, NCN5654PLiebrecht Dennis L DBA · Ocala, FLN5656PTaylor National Transportation LLC · Palatine, ILN5670PBas Part Sales LLC · Greeley, CON5674PNeely Antwuan T · Savoy, ILN5675PLandolt Gregg E · Moreno Valley, CAFirst renewal noticeN5678PWhite John O · Camarillo, CAN5679PKuehnert Stefan · Clarkesville, GAN5684PAce Drilling LLC · Johnson, KSN5686PGray Gary L · Frederick, OKN5691PCoady Michael · Taylorville, ILN5693PBays Aviation LLC · Boerne, TXN5699PHahn Curtis D · St George, UTN56CCMichel David L · Pickens, SCN5700PEdmundson George · Burlington, WAN5702PChilds Group Inc · Altoona, IAN5705PN5705p Inc · Pompano Beach, FLN5709PSaadjack LLC · Amelia Island, FLN5712PGibson Kevin M · Denver City, TXN5717PGraber Tim B · Santee, CAN5720PPatterman Emil S · Fort Worth, TX
Back to AD 2012-17-06