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.
N78WVOrange Motion Trading LLC · Las Vegas, NVN78WWPark Avenue Group Inc · Stuart, FLN79007Hardy Robert C · Plantation, FLN7901QKentucky Airmotive Inc · Mount Sterling, KYN7909QSky West Aviation Inc Trustee · Albuquerque, NMN7912QHagan David · Overgaard, AZN7913QBrown Kevin B · Eureka, MTN7916CEchelon Capital Aviation LLC · Palo Alto, CAN791BBG-4 Aviation LLC · Delaware, OHN791GTGolf Tango Aviation 2 LLC · Johns Creek, GAN791KDKrupa Rafal · Hampstead, NCN791LHFancy Dog Aero LLC · East Wakefield, NHN791SDSeery Loren · Spokane, WAN7920JClear Creek Medical Corp · Arcata, CAN792JHElgee Aviation LLC · Fairfield, NJN792PGWestchester Airplane Rental II LLC · Larchmont, NYN792PS792ps LLC · Franklin, TNN792SDSnoopdoodle Air LLC · Plano, TXN792SRBest22 LLC · Phoenix, AZN792TMWalk On Holdings LLC · Hattiesburg, MSN79336Yaggie Allen · Wahpeton, NDN793CDRbj Tn Holdings LLC · Cleveland, TNN793JHHandmade Wings LLC · Covina, CAN793KBRyal Holdings LLC · Jamestown, CAN793LMJohnson Roger C · Lake Havasu City, AZN793MSLeblanc Paul W · Wapakoneta, OHN794ABKodiak Brands Inc · Fairview, TXN794LBLb Aviation LLC · Norma, NJN794PCFlioway LLC · Iowa City, IAN795AMBoone Aviation Services LLC · Winston Salem, NCN795ATWarbirds-3 LLC · Kalispell, MTN795EEHummingbird H2 LLC · Amarillo, TXN795SCN795sc LLC · Byron Center, MIN7969QBadenhope John R · Greeneville, TNN796PGSaco Leasing LLC · Dunwoody, GAN797BTCollins Jeffery Scott · Fort Myers, FLN797CDPhronesis LLC · Tucson, AZN797CKYale Aviation LLC · Ariel, WAN797EECoast To Coast Restoration LLC · Theodore, ALN797HGBearaire LLC · Fairport, NYN797JKReefbound Ventures LLC · Raleigh, NCN797KABank Of Utah Trustee · Salt Lake City, UTN797RACool Air Travel LLC · Macon, GAN797SMLowry Michael R · Los Altos Hills, CAN797SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN797TN797t Aviation LLC · Stanfield, NCN797VTGrace Aviation LLC · Canton, GAN7981Amjem Aviation Holdings LLC · Aurora, OHN7983QLorenso Walker Institute Of Technology · Naples, FLN7989QLauritano Stephen G · Goodyear, AZ
Back to AD 2012-10-13