AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N5268Evans Eric A · Saint Peter, MNN52686Heartland Aviation LLC · Ada, OKN526BPutnam Michael C · Topeka, KSN526PHangar Four LLC · Blue Ridge, GAN526PMMccandless Malinda Sue · Sussex NbFirst renewal noticeN5270CLohr David C · Wrightwood, CAN5271CSale Reported · Davis, CASale reported, pending cancellationN5272CDiehl Ross E · Chino, CAN5278CMoore Louis · Rutland, VTN527MLMoss Herman D · Centreville, VAN527QSilver Linings Air And Farm LLC · Chamblee, GAN527RABonanza Parts Inc · Davis, CAN527RSLookout Mountain LLC · Mill Valley, CAN527TFlying H Enterprises LLC · Smithville, MON527TCLeonardo Paul A III · Merced, CAN5282COrr Kent C · Kearney, NEN5283MPskd Limited LLC · Upland, CAN5285CElkins Quentin D · Andersonville, TNN5286MSwift Aviation LLC · Silverdale, WAN5289MHardy Caitlin M · Woodinville, WAN528EWNc Aviator LLC · Fuquay Varina, NCN528LCSaunders Michael · Argyle, TXN528PLebanon Air Taxi LLC · Hanover, NHN528TTaylor Edith E · Como, NCN5294Brown Kevin Lee · Broseley, MON52962Worlds Greatest Aircraft Collection Inc · Polk City, FLN5298CCheshire Derek L · Mercer Island, WAN529BBCarnahan Charles Christopher · Wentzville, MON529CCC747 LLC · Wilmington, DEN529DDSchwertfeger Dean · Woodruff, WIN529JAAnton Aaron · Poplar Grove, ILN529PHoffman Andrew · Martinsville, INN529RBBusby Ralph H III Trustee · Newport, ORN529SARaptorsair LLC · Mchenry, ILN52AAWebster Patrick Edward · Elk Grove, CAN52AUUllman Aaron L · Barksdale Afb, LAN52CEUlmer Ken W · Houston, TXN52DNAir Apparent Aviation LLC · Plant City, FLN52HCOak Bay Aviation LLC · Bellvue, WAN52JMJetstar Aviation Group LLC · Norlina, NCN52KTMontgomery Transit LLC · Fulton, MSN52LGGroom Lincoln · Wadmalaw Island, SCN52LVAltair Aircraft LLC · Gainesville, FLN52MBRoark Dale L · Cheyenne, OKN52RARennenkampf Erik J · Columbia, MDN52SBRedwood Oil Co Inc · Rohnert Park, CAN52SCTaylor Aaron Lee · Salado, TXN52TADowell Thomas · New Smyrna Beach, FLN52TZTurley Dale R · Poway, CAN52VBHarral Vaughn R · Prescott Valley, AZ
Back to AD 99-05-13 R1 WD