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.
N3232WKilgallen Keith S · Stuart, FLN3233GMach Aviation Pilot Services LLC · Andover, KSN3233JZebcon Inc · Russellville, ARN3233LMann Aviation LLC · Wilmington, DEN3235DMdb Ventures LLC · Wausau, WIN3235TBhatia Kabir · Lake Oswego, ORN3236QBo'S Investments LLC · Amarillo, TXN3236THg Aviation LLC · Helena, MTN3236ZJuliet Sierra Foxtrot LLC · Denver City, TXN3238YKorff Aviation LLC · Leesburg, VAN3239WHaidlen Ford Inc · Oakdale, CAN323BMMav-Cat Aero LLC · Bremerton, WAN323CDMesibov Steven · Deland, FLN323CLHoge John · Setauket, NYN323DASky West Aviation Inc Trustee · Albuquerque, NMN323DCFlymax Aircraft LLC · Ball Ground, GAN323DMWard Frank J · N Richland Hills, TXN323FLSch Aviation Inc Trustee · Sporle Kings LynnN323KCBig Blessing LLC · Saint Louis, MON323KGN1234 LLC · Costa Mesa, CAN323LMSandcastle Jwm Properties LLC · Paradise Valley, AZN323MFFla Capital LLC · Newark, DEN323PMSrc Property LLC · Alpine, TXN323RBAvion Flight Services LLC · Rome, GAN323RCTigers Aviation LLC · Wasilla, AKN323TJGuardian Wings LLC · Fredericksburg, VAN323TLPrime Aviation Leasing LLC · Westlake, TXN323WWhitewings Aviation LLC · Milton, GAN323WDDurand Paul C · Osceola, WIN323YManthei Kurt E · Jacksonville, FLN3240NAir Services Of Mississippi Inc · Mccomb, MSN3243BKcirro LLC · Portland, ORN3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CAN3246BRb3246b LLC · La Follette, TNN3246RRegistered aircraftN3247PCary Leasing & Management LLC · Boerne, TXN3247XExcalibur Aviation LLC · Spencer, IAN3248LPreferred Management Corp · Shawnee, OKN3248TBrydon Robert J · Austin, TXN3249DBielanski Allan · Larkspur, CON3249JSelge Leasing Inc · Niles, MIN324ABLightning Aviation LLC · Parrish, FLN324AJ324 Aj LLC · Roseville, CAN324BRBlue Ridge Aviation Holdings LLC · Boone, NCN324CDWalker Synergy Partners 367 Inc · Encinitas, CAN324GEGreat Aviation LLC · Michigan City, INN324GT324 Aviation LLC · Cavour, SDN324QLove Charles Keith · Asheville, NCN324RDGood Voyage LLC · Sullivans Island, SCN324SRThree Bell Aviation LLC · Dallas, TX
Back to AD 2012-10-13