AD 2019-08-13
Registered aircraft · 1,554
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:2019-08-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:2019-08-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:2019-08-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:2019-08-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.
N25SJR&T Aviation LLC · Pontiac, MIN260AMQualitair LLC Trustee · MichelstadtN262BKOmicron Business Services Inc · Winter Park, FLN262DALr Forage Harvesting LLC · Energy, TXN263FBCrye-Leike South Inc · Memphis, TNN264CEFly Invest Inc Trustee · Wilmington, DEN267BGCardinal Scale Manufacturing Co · Webb City, MON26AUnlimited Boat Sales Inc · Page, AZN26DTMdr Construction Inc · Columbia, MSN26RLJs Aircraft LLC · Eden, NCN273RJDylans Rv Center LLC · Waterford Works, NJN274DTCentral Connecticut Aircraft LLC · Plainville, CTN275LXLanier Flight Express LLC · Gainesville, GAN277VC9012newhere LLC · Wilmington, DEN278KThienes Engineering Inc · La Mirada, CAN278LNMonticello Air LLC · Napa, CAN279DLdt Aviation LLC · Coral Gables, FLN27CJ411kc LLC · Tuscaloosa, ALN27CNDn525 Capital Holdings LLC · Plano, TXN27EWTextron Aviation Inc · Wichita, KSN27PLMwbp Foundation LLC · Tulsa, OKN27VQAlcyone Trust Corp Trustee · Wichita, KSN282WBRight Rudder Inc · Wilmington, NCN283RACho Oyu LLC · San Antonio, TXN285FWApex Cj1 LLC · Cypress, TXN286NInfinity & Beyond LLC · South Bend, INN287CBCottingham & Butler Insurance Services Inc · Dubuque, IAN287NNicholas Services LLC · Oxford, MSN288G4m Aviation LLC · Fort Worth, TXN288STextron Aviation Inc · Wichita, KSN289RTJp Aviation LLC · Petaluma, CAN28CKC Star Aviation LLC · Evansville, INN28DMMachavia Inc · Christiansted, VIN28FDPacific Air Center LLC · Long Beach, CAN28QAHuff Air LLC · Uvalde, TXN28RKRd Aviation Lp · Redlands, CAN290CJLucky Stars LLC · Missoula, MTN294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN294PWSierra Papa II LLC · Bakersfield, CAN295DS4f Managment LLC · Salem, ORN295LBuilding Corp LLC · Huntsville, TXN295MLCorning Companies LLC · Billings, MTN298CJN298cj LLC · Friendswood, TXN29MCValiair Lc Trustee · Casper, WYN2AZWilmington Trust Co Trustee · Wilmington, DEN2BDOral Arts Dental Services LLC · Huntsville, ALN2SYYocham J Scott · Mc Gregor, TXN2ZBCitizen Aero Inc Trustee · Sheridan, WYN300BVCj Bravo Victor LLC · Ridgeland, MSN300FCDresden Aviation LLC · Atlanta, GA
Back to AD 2019-08-13