AD 2002-07-01
Registered aircraft · 3,466
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-07-01')
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-07-01')
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-07-01') 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-07-01') 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.
N763United States Department Of Interior · Boise, IDN764Usda Forest Servic Fepp · Columbia, SCN764RBReo & Bpo LLC · Lewes, DEN764SAerotrans Management LLC · Mercer Island, WAN767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKN7685NFranklin Construction Inc · Chico, CAN7691DScout Aviation LLC · Homer, AKN769BSWells Donald T · Seattle, WAN76BLBravo Lima Corp · Lakewood, CON76DACessna 76da LLC · Warsaw, VAN76EDFlying Hawks Ranch LLC · Bruning, NEN770CFKopp Adrian D · Brookville, INN7711DCaldwell Joel A · Kenai, AKN7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeN77206Venture Alaska LLC · Homer, AKN7723MDdw Inc · Gardner, CON7736KValiair Lc Trustee · Casper, WYN773DWWalerius Dennis · Sylvania, OHN774CSWyo Ventures LLC · Buffalo, WYN774RDDemuth Roger C Trustee · Valley View, TXN77554U S Department Of The Interior · Boise, IDN776TMAero Performance LLC · Scooba, MSN7774BAdair Aviation LLC · Broken Arrow, OKN7776HAcevedo Adriel · San Antonio, TXN7777ALibby Stephen R Trustee · Anchorage, AKN7777SHood Company LLC · Nashville, TNN777BMJet Air Of South Florida Inc · Deerfield Beach, FLN777CFCp Aviation LLC · Pasco, WAN777DLShamrock Kelly Energy Inc · Blanco, TXN777FWLewis Kent · Lake Oswego, ORN777FYQualitair LLC Trustee · ChelstadtN777HSJohnson Erik L · Long Beach, CAN777NTN777nt LLC · Fort Mill, SCN777RKing Winn K · Gladewater, TXN777RRChalk 2 Inc · Apple Valley, CAN777SZMullen John J Jr Trustee · Henderson, NVN777WLAerospace Trust Mangement LLC Trustee · Wilmington, DEN778CWGarbati Thomas Jr · Waterford, CTN778VKPuerto Rico Management Services Inc · Coral Gables, FLN7798NGebhard John M · Hartland, WIN77BVRegistered aircraftN77CKRaiz Coaching LLC · Fort Worth, TXN77CRVolatile Aero Ventures LLC · Boulder City, NVN77GSSouth Carolina Flyers LLC · Aiken, SCN77KRMarsh Aviation LLC · Old Lyme, CTN77RASky West Aviation Inc Trustee · Albuquerque, NMN77WSRegistered aircraftN7806SAeroquest LLC · Plano, TXN780ALas Margaritas Aviation LLC · Qulin, MON780ESFlying Pineapple LLC · Naples, FL
Back to AD 2002-07-01