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.
N6019FFlying R LLC · Apison, TNN601BTCoats George A · The Woodlands, TXN601RKNorthampton Aeronautics Inc · Northampton, MAN601SGBrynildson Scott W · Rifle, CON601SWDynaero LLC · South Vineland, NJN601UJBurton Donald O · Mooresville, NCN6020EDominianni Michael J · Chester, NJN6020PClark Katherine A · Spring, TXN6021EMerhar Timothy J · Shoreview, MNN6021PPullman Eric B · Wurtsboro, NYN6022EWard John B · Fishers, INN6022MWolf Richard J · Apple Valley, CAN6022SAhlberg Merick D · Eagle River, AKN6022WDelgado Mario J · Baldwin Park, CAN6023QCr Mcdowell Construction Co Inc · Keokuk, IAN6023UHigh Scott · Albuquerque, NMN6023ZSchmauderer Ivan K · Woodland, CAN60244Ace Of Spades Aviation LLC · Las Vegas, NVN6024AAerospace Trust Management LLC Trustee · Wilmington, DEN6024KNabarrette Angel · Odessa, TXN6024QAero Equities LLC · Ventura, CAN6024SAdams Erik S · Bozeman, MTN6024U6024u Aircraft Leasing LLC · Spanish Fork, UTN6024XWmrm LLC · Saint Petersburg, FLN6024ZProag Services Inc · Mahnomen, MNN6025RScott James C · Akron, OHN6025TVtales LLC · Urbana, ILN60264Buttram John Randal · Panama City, FLN60268Rougher Aviation LLC · Council Hill, OKN6026ERegistered aircraftN6026UJohnsson Johan C · Monterey, CAN6026YWestern Flying Club Inc · Burlington, NCN6027EJava LLC · Oxford, MSN6027FPease David · Santa Cruz, CAN6027GBell William F · Hartwell, GAN6027UKolesar Mark A · Golden Valley, MNN6028EChiappe Glenn R · Lago Vista, TXN6028FFlying Ospreys LLC · Camas, WAN6028SHazellief Joe · Okeechobee, FLN60295Neufield Jim R DBA · Wasco, CAN6029FTeeple Leighton B · Plainview, TXN602BMeyer Charles H · Stratford, CAN602DKGingerjet LLC · Boca Raton, FLN602FCStarr Travis W · Helotes, TXN602PPayne Mark Robert Jr · Germantown, TNN60306Ibikunle Christopher S · Grayson, GAN6030RMaresco Services Inc · Alpha, NJN6030WAllen James Robert · Glasgow, KYN6030ZBeeline Aero LLC · Scottsdale, AZN60329Beech Bumz Aviation LLC · Tarpon Springs, FL
Back to AD 99-05-13 R1 WD