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.
N321RRambarran Brian D · Clarence Center, NYN321SMLucky Stars LLC · Missoula, MTN323ADShc Citation LLC · Jonesburg, MON323EZN323ez LLC · Amarillo, TXN323SKMacd Capital LLC · Newark, DEN324AMP & M Leasing Inc · Green Bay, WIN324AVAvalair Aircraft Management LLC · Brookshire, TXN324BDGodwin Aviation LLC · Dunn, NCN325ATBtr Air Charter Cj LLC · Baton Rouge, LAN325GHBtr Air Charter Cj II LLC · Baton Rouge, LAN325MLWhen Pigs Fly Aviation LLC · Lawler, IAN325RCCharlie Bravo Leasing LLC · Chandler, AZN325WCAlcjr LLC · Pataskala, OHN326JKRiver Bank Aviation LLC · Dover, DEN327TXLucky Devil LLC · Scottsdale, AZN328CJRegistration Pending · College Grove, TNRegistration pendingN329BHJos Aviation LLC · Conrad, IAN32ACAlliance Service Inc · Lexington, KYN32BBGee Aviation Inc · Sturgis, KYN330WSValiair Limited Co Trustee · Casper, WYN331GGGed Jet LLC · Boca Raton, FLN331MPMartins Famous Pastry Shoppe Inc · Chambersburg, PAN331PLPremier Aircraft Trading Service Inc · Lewes, DEN331XAJetnexa Three LLC · Gilbert, AZN333BDFour Rings Aviation II LLC DBA · Gainesville, TXN333SLT C Air LLC · West Linn, ORN333XAJetnexa One LLC · Gilbert, AZN335JJFlybiz LLC · Zeeland, MIN33BKIronman LLC · Arlington, VAN33BSIncomm Cj3 LLC · Atlanta, GAN33BWMecum Auction Inc · Walworth, WIN33DTN33dt LLC · Phoenix, AZN33FWNext Level Aviation Group LLC · Sarasota, FLN33NMBighorn Airways Inc · Sheridan, WYN33UMFirst Charter Service Corp · Ann Arbor, MIN341ARMla Management LLC · Salt Lake City, UTN341NLucky Stars LLC · Missoula, MTN345CJBrantigan Research LLC · Kalispell, MTN346PAAb Jet Co Vi LLC · Metairie, LAN3478STrend Aviation LLC · Lafayette, LAN347BCRoni 1 LLC · Sacramento, CAN34RLKar2 Inc · Sevierville, TNN34SJGamma2 Inc · San Marcos, CAN34TCHuff Air LLC · Uvalde, TXN350BVDiane S Lake-Ca LLC · Bakersfield, CAN351AJR2 Enterprise Holdings LLC · Chandler, TXN351BCInternational Bank Of Commerce · Laredo, TXN351BFKbs Aviation LLC · Springboro, OHN352AVAvalair Aircraft Management LLC · Brookshire, TXN356DCZephyr Air LLC · Orlando, FL
Back to AD 2019-08-13