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.
N923PMNeuhaus George W · Skokie, ILN923PTMiller Light Investments LLC · Mcalester, OKN923TPEcho Sierra Holdings LLC · Johns Creek, GAN923WSHmsi Air Inc · Castle Rock, CON924ALCom Air LLC · Jackson, MON924BMAviation Industries LLC · Aurora, ILN924CDSunshine Holding LLC · Danbury, CTN924CFWillowwood Aviation LLC · San Francisco, CAN924PHayabusa LLC · Bluffton, SCN924TKKwality Aviation LLC · Mamaroneck, NYN924WOcean Isle Aviation LLC · Ocean Isle Beach, NCN925CCN925cc Inc Trustee · Wilmington, DEN925CGTabor Holdings LLC · Wolcott, CON925CSAscension Investment I LLC · Ormond Beach, FLN925KDBenson Thomas W Trustee · Weston, MAN925LBPanasuk Gary A · Lyons Falls, NYN925LCBlue Angel LLC · Northville, MIN925MSBargfrede Bernard Trustee · Blackburn, MON925PCLee Investment Services LLC · Madisonville, TXN925PDC2 Aviation LLC · De Soto, KSN925PWN37gd LLC · Fort Myers, FLN925RCCastle Shelter Group LLC · Clearwater, MNN925RJHammer Neil A · Alexandria, MNN925SEValiair Lc Trustee · Casper, WYN925TPKtm Projects LLC · Durant, OKN925WMHoward Charles M · Pittsburg, TXN926Ascent LLC · Sioux Falls, SDN926CDZimmerman Aircraft Rentals Inc · Friedens, PAN926CWValley Flyway LLC · Merced, CAN926DCTt Aviation LLC · Henderson, TXN926DMTurner Strategic Technologies LLC · Norfolk, VAN926JNWindfield Management LLC · El Paso, TXN926KJIdeal Aviation LLC · Charlotte, NCN926KSKns Timeless Design LLC · Newark, DEN926KWClear Sky LLC · Newmarket, NHN926MTNew London Aviation LLC · Forest, VAN926SJFriday Bay LLC · Santa Barbara, CAN926TK8 Point Aviation LLC · Waltham, MAN926WGDollar Aviation LLC · Bainbridge, GAN92711Intergard R&D LLC · Miami, FLN9275YInternational Air Services Inc Trustee · Carson City, NVN927AWLambert Contracting LLC · Hollywood, ALN927CDCotton Stephen P · Midland, MIN927CRAero Fudo LLC · Hudson, OHN927CSLure Jet LLC · Woodinville, WAN927DBBrummett Enterprises Of Somerset LLC · Somerset, KYN927JVne Enterprises LLC · Oneida, TNN927MBGlobal Aircraft Management And Operations LLC · Thomasville, GAN927MLSmair Holding LLC · Tampa, FLN927SFShared Flight N927sf LLC · Berryville, VA
Back to AD 2012-10-13