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.
N8485NBenningfield James L · Plano, TXN8488NStevens John C Jr · Texarkana, ARN848JDTurner Michael A · Cartersville, GAN8490AUrquhart Dan DBA · Fallon, NVN8490NTower Kevin K · Connersville, INN8491NMarius Aviation LLC · Northport, ALN8493NSoderblom Edward J · Ferndale, WAN8494NLemons Hayden · Conway, ARN8495AQualitair LLC Trustee · MichelstadtN8496NIsaacs Brandon · Homedale, IDN8497AHaynie Walter R · Brooklyn, IAN8498AAllen Scott C · Mcminnville, ORN84AKMetro Aviation Inc · Shreveport, LAN84BReturnlogic Inc · Apollo Beach, FLN84BBKauffman Concrete LLC · Wilmington, DEN84BEVelasquez Daniel A · Winter Park, FLN84BFEvans Timothy Kent · Fremont, NCN84BHFredrick Matthew W · Pooler, GAN84BTSoltani Ebrahim · Palos Verdes Est, CAN84DSankofa Air LLC · Wilmington, DEN84FBJohnson David P · Sycamore, ILN84KN84k LLC · The Dalles, ORN84LBLiess Zenda A · Greensboro, NCN84PECarosso Kevin V · Santa Cruz, CAN84RSanford David G · Knoxville, TNN84SRSunnydaze Ltd · Northville, MIN84TAAnderson Wallace A · Melbourne, FLN84TTRenda Michael A · Sunrise Beach, MON84WHWhiskey Hotel Aviation LLC · South Hill, VAN84WSByham Shawn G C · Lake Havasu City, AZN8500MThomas Kent J · Wilsonville, ORN8501ARosanova Richard Shane · Flagstaff, AZN8503MPlatt Anthony Eric · Riverside, CAN85052Gant Dallas C Jr · Wickenburg, AZN8505MRegistered aircraftN8506MMichaels Daryl · Owasso, OKN8507ATidwell Jim O · Canton, GAN8507MSutliff Geoffrey A · Sacramento, CAN850BCadieux Gregg M · Scotia, NYN850CMN850cm LLC · San Luis Obispo, CAN850DCGolden Compass Aviation LLC · Wilmington, DEN850TWisdom John D · Mineola, TXN850YRNhv LLC · Orlando, FLN8511ASipple Ronald W Jr · Gardner, KSN8511MJ & J Aviation Services LLC · Simpsonville, SCN8512MMalone David Dean · Carefree, AZN8514MSummerland Spins LLC · Summerland Key, FLN8515MSegura Richard J III · Henderson, TXN8518ALapinel Marc P · Long Beach, NYN8519AMyers Travis · Bridgeport, WV
Back to AD 99-05-13 R1 WD