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.
N615CMA Cirrus Life LLC · Santa Barbara, CAN615DWMantis Aviation LLC · Arrington, TNN615EMGinther Associates LLC · Hillsdale, NYN615HBButterbean Aviation LLC · Brentwood, TNN615JPBeyer Munch Enterprises LLC · San Antonio, TXN615KN981k LLC · Nashville, TNN615LMPerrett Construction Ltd · Valentine, NEN615LTAlmo Air LLC · Albuquerque, NMN615MBTango Sierra LLC · Kalispell, MTN615MPMorning Star Transportation Inc · Dardanelle, ARN615PCBurning Blue LLC · Greenwood, MSN615PJEngelstad Dana P · Midland, TXFirst renewal noticeN615PWCardiac LLC · Amarillo, TXN615PXKempton Robert · Tampa, FLN615SALordemann Holdings LLC · Kalispell, MTN615SMWjjw Interests LLC · Chappell Hill, TXN615TMMlp Aviation LLC · Phoenix, AZN615TNNagy Timothy E · Franklin, TNN61609Eriksen Bjorn A · Polson, MTN6161NOn Eagles Wings LLC · Los Gatos, CAN6161ZSkybound Holdings LLC · Orlando, FLN6162CHeller Casey · Williston, NDN6162XCapital Holdings 149 LLC · Kearney, NEN6167CSnyder Larry G · Holland, NYN6168NRegistered aircraftN616ASBrozzo Ralph A · Midland, MIN616ATMartin Ingram Enterprises Inc · Dallas, TXN616BPAesthetic Surgeons Leasing LLC · Birmingham, ALN616CWDixie Air LLC · Russell Springs, KYN616GROld Goat Aviation LLC · Chattanooga, TNN616JNBatten Aviation LLC · Lancaster, OHN616MB6mb Partners LLC · Burleson, TXN616MSBledsoe Bobby H · Hot Springs, ARN616RMMnemonics Inc · Melbourne, FLN616SGDei Flight Inc · Stoughton, WIN616SJRegistered aircraftN616SPAdmiral Aviation Holdings Lp · Summerville, SCN616ZW16 Paws LLC · Navarre, FLN6170NGarmin210 LLC · Willard, MON6171ZTennessee Valley Aviation LLC · Fayetteville, TNN6173RBeyer Livestock Auction LLC · Clovis, NMN6174BN6174b LLC · Nokomis, FLN6177XMayhew William D · Round Lake, ILN6178WBlu Sky Key West LLC · Key West, FLN617CPDaccarett Miguel S · Chicago, ILN617DTCacoum LLC · Boca Raton, FLN617JJAviazione Leoni LLC · Miami, FLN617KHPiscosos Inc Trustee · Wilmington, DEN617PCBurns Keith D Trustee · Tower, MNN617THCain Daniel · Topsail Beach, NC
Back to AD 2012-10-13