AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N992PJOld Guys In The Sky LLC · Winton, CAN992PSProctor Gary · Wichita, KSN992RJKnight Rider LLC · Kalispell, MTN992TLMulzer Timothy J · Santa Claus, INN992TSTvpx Ars Inc Trustee · North Salt Lake, UTN9934XLogue James · Fort Worth, TXN993JTGood Life Aviation LLC · San Tan Valley, AZN993LLSherpa Aerospace LLC · Tucson, AZN993MMMccormick Aviation LLC · Madisonville, LAN993MSMs600 Fl LLC · Miami, FLN993PMMakai Royalty LLC · Spicewood, TXN993SMCharden Aviation LLC · Mount Sterling, KYN993SRThree S Ranch Inc · Blanca, CON9940FHarvey Air LLC · Arlington, TNN9943COwl Ventures LLC · Portland, ORN9948ZAlien Invaders LLC · Medina, WAN994CERegistration Pending · Coeur D Alene, IDRegistration pendingN994CTUS Framing International LLC · Louisville, KYN994EFRbav LLC · Camden, DEN994KDKgd Aviation LLC · Breckenridge, CON994NZFrakes Stephen A · Frisco, CON994PMooney Travel LLC · Newport, RIN994PMAlpha Dogs Aviation LLC · Powell, OHN994PXFlight Charter Services LLC · Missoula, MTN994SBB Squared LLC · Russellville, ARN9952ZMcdougall Enterprises LLC · Tualatin, ORN9953CEjj Group Inc · New York, NYN9955JMehling Robert C · Hardin, MTN9955MBell Jason W · Mount Pleasant, TXN995EGEagle Group USA Inc · Howell, MIN995KClemmer Norman L · Green Lane, PAN995SDDarcy Aviation LLC · Scottsdale, AZN995TBTravel Lecture Learn LLC · Sicklerville, NJN995WASheely Holdco LLC · Chesapeake, VAN995WBTrue North Aviation LLC · Harrisburg, SDN995WSN995ws LLC · Fairfax Station, VAN9963HRoni 1 LLC · Sacramento, CAN9963WStokair LLC · Mequon, WIN9963YN9963y LLC · Provo, UTN9964YGreenspun Mark H · Washington, DCN9968JBoening Bros Dusting & Spraying Scv · Floresville, TXN9968PFlax Brian J · Germantown, TNN996AElite Air Ventures LLC · Concord, CAN996CDGrace Flying Service Inc · Saint Francis, KSN996FInloes Mechanical Utah LLC · Ogden, UTN996JKFletcher Flying Service 419 LLC · Labelle, FLN996SMMclay Colin Alasdair · Navasota, TXN9976MBrush Wesley A · Sparks, NVN9977JBoening Bros Dusting & Spraying Inc · Floresville, TXN997AJSky Ark LLC - Series 2 · Las Vegas, NV
Back to AD 2012-10-13