AD 2000-07-03
Registered aircraft · 557
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:2000-07-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-03')
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:2000-07-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-07-03') 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.
N7195HGregory Family Farms LLC · Lewes, DEN7195PSpitzer Helicopter LLC · Woodland Hills, CAN7196HState Of Alaska · Anchorage, AKN7196UThomas Aviation LLC · Orleans, CAN7197JBrown Ronnie J · Anahuac, TXN7197VExecutive Helicopters Inc · Myrtle Beach, SCN724RGHeli Guide Leasing Inc · Crystal Beach, FLN725SMS&M Aviation LLC · South Boston, VAN727DTClassic Drywall LLC · Richmond, KYN727KPAero Leasing Inc · Brookings, ORN728PGPolar Star Corp · Kalispell, MTN728TSSky King LLC · Baltimore, MDN739ASDel Martin Lp · Spring, TXN740RHUnited Helicopter Leasing LLC · Honolulu, HIN74335Owyhee Rotors Inc · Grand View, IDN743RGRio Grande Helicopters Inc · Laredo, TXN74401Iron Bird Aviation LLC · Wahpeton, NDN74499Dawn Wolf Technologies Inc · Wichita, KSN744AFCm3 LLC · North Las Vegas, NVN744CJJersey Aviation LLC · East Orange, NJN744HSAnthelion Helicopters · Long Beach, CAN744RGJohnston Philip · Mountain Home, TXN74508Agricultural Tours LLC · Cheyenne, WYN747WDJohnston Philip M · Mountain Home, TXN74EPCantrell Grady DBA · Los Banos, CAN74RGRio Grande Helicopters Inc · Laredo, TXN7507XGhgk LLC · Myrtle Beach, SCN7510TSpitzer Helicopter LLC · Woodland Hills, CAN7511WTtwn Media Networks LLC · New York, NYN75175November Alpha LLC · Dover, DEN7519GStearns William W · Talkeetna, AKN7523EFlying J Services LLC · Jourdanton, TXN752ECAll Planes & Helicopters Corp · Pompano, FLNon-citizen corporation, flight hours not reportedN7530CLake Superior Helicopters LLC · Duluth, MNN754BASouthern Aircraft Consultancy Inc Trustee · Casper, WYN765CMLaurel Highlands Helicopters Inc · Latrobe, PAN76MBHolt Helicopter Inc · Uvalde, TXN7700ATim Whitfield Aviation Inc · Fairfield, NCN777RLLandau Management Services Inc · Toranga, CAN7786JHeadings Norman D · Walnut, ILN77DDFenger Thomas A · Palmer, AKN77GDN77gd LLC · Kalispell, MTN77JARegistration Pending · Midlothian, TXRegistration pendingN77MGHelo LLC · Easton, PAN792CCGavranovic William J Sr · Wharton, TXN79RHNowling Daryl · Palm City, FLN7QHPfannenschwarz Harry · Odessa, FLN8035Sparta Rotors Inc · Stuyvesant, NYN804NVMoody Bible Institute Of Chicago · Spokane, WAN806NVFlight Operations Inc · Lewes, DE
Back to AD 2000-07-03