AD 2002-11-07
Registered aircraft · 1,512
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:2002-11-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07')
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:2002-11-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07') 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.
N200RTRiley Nolan C · Lubbock, TXN2018LKrielow Law Firm LLC · Thibodaux, LAN201DRegistered aircraftN2021UAll Airline Pilot Training LLC · Delray Beach, FLN2022TAero-Marine LLC · Miramar Beach, FLN2023CFulps Aviation LLC · Winston Salem, NCN2026WGta Air Inc · Addison, TXN2027DNichols Neil A · Aalachicola, FLN2027UJpb Diversified LLC · Auburndale, FLN20292Laflight LLC · Goldsboro, NCN202PSc Infinities LLC · Dover, DEN2031ZJames Jeb S Dr · Bay City, TXN2041ZBlue Mesa LLC · Bend, ORN2043ACampion Richard · Tampa, FLN2044ABrowder Daniel Klemp · Shady Valley, TNN204GAirmart Inc · Lexington, KYN2056NN2056n LLC · Wilmington, DEN2058CScorpion Aviation LLC · Hemet, CAN2058KCollins Jimmy · Spring, TXN2059PNiemi Aviation LLC · Glyndon, MNN2059XK Wings LLC · Golden Valley, MNN205AGWing Men LLC · Cleveland, OHN205KTMha Interests LLC · Spring, TXN20602Bromschwig Kurt F Trustee · Montgomery, TXN2061KMile High Air Inc · Canyon, TXN2063GHolman Allen S · Knoxville, TNN2064VGta Air Inc · Addison, TXN2069KFiloteo James · Woodinville, WAN2069YBeach Helicopter Services LLC · Chesapeake, VAN2070LBaron 70 Lima LLC · Modesto, CAN2073LBravo Wings II LLC · Grants, NMN207ZMInternational Air Services Inc Trustee · Carson City, NVN2082LChronicle Aerospace Inc · Wilmington, DEN208PGrateful Center Transportation LLC · Lutz, FLN210DAStroemsvik Kristian · Strasburg, VAN2110AWindshear Aviation LLC · Longmont, CON2110LMalco Power Design Co Inc · La Marque, TXN2119LCannon Thomas W · Tiki Island, TXN211AA1776 Aviation LLC · Kalispell, MTN211MWGoad Jerry A · Oneida, TNN212ASKff Inc · Piscataway, NJN212CHFlycarolina Ll · Concord, NCN212PPLermer Christoph · Naples, FLN212TWLeaving On Tulsa Time LLC · Tulsa, OKN2130LTds Property Holdings LLC · Gilmer, TXN213CHEz Aviation LLC · Morrisville, NCN2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2146LDm Group LLC · Troutman, NCN214CHFlycarolina LLC · Concord, NCN214KPBnb Aviation LLC · Chesterfield, MO
Back to AD 2002-11-07