AD 2002-01-09
Registered aircraft · 439
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-01-09')
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-01-09')
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-01-09') 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-01-09') 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.
N554VRCoastal Aviation Holdings LLC · North Charleston, SCN555EWSilver Lake Aero Investments LLC · Craig, AKN557PCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559AJBillings Flying Service LLC · Billings, MTN559PBEmpty Rain Aviation LLC · Broomfield, CON55BKPc 12 LLC · Sterling, VAN55WPRichardson Farms Outfitters Inc · Pittsfield, ILN561STCharter Fx LLC · Crestview, FLN562NARegistration Pending · Greenwood Village, CORegistration pendingN567QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN571PCDg & Ag LLC · Albuquerque, NMN572PCPierson Aviation LLC · Charlotte, NCN575PCOsaka Holdings LLC · Austin, TXN576RGBob Air LLC · Atherton, CAN577BFLiberty Air LLC · Prescott, AZN578JZAcv Group LLC · Mckinleyville, CAN57LTLexington Turbo LLC · Southborough, MAN580HSH&S Constructors Inc · Corpus Christi, TXN581PCUS Air Force Special Operations Command/A5km · Hurlburt Field, FLN582DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN584JVTargaryen LLC · Denver, CON584STNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN588KCTejas Global Trust LLC · San Antonio, TXN589QDQuest Diagnostics Clincal Laboratories Inc · Reading, PAN5904ALaboratory Corporation Of America Holdings · Burlington, NCN590TWPriority Air Charter LLC · Kidron, OHN591SSCommercial Air LLC · Reno, NVN593PCUS Department Of Homeland Security · Washington, DCN594WAFifth Direct Air LLC · Polson, MTN598MMHang Time LLC · Charlotte, NCN599PBEdgewater LLC · North Charleston, SCN5DMGuardian Flight LLC · Lewisville, TXN600WYAereo LLC · Casper, WYN601BGManagement Systems Corp · Grand Forks, NDN605PCLogan Health Medical Center · Kalispell, MTN60LTEastern Stearman Inc Trustee · Leesburg, VAN60WPTrinity River Lumber Co · Weaverville, CAN610GHHtc Aviation LLC · Lititz, PAN612CRDiamond Resorts West LLC · Edwards, CON612JSmith Frank Ford Jr · Wilmington, DEN612KCHillcrest Aircraft Co Inc · Lewiston, IDN616EAEmpireair LLC · Spokane Valley, WAFirst renewal noticeN618JCMclean Aviation Services Inc · Napa, CAN618SLewis Aeronautical LLC · San Antonio, TXN620WALaboratory Corporation Of America Holdings · Burlington, NCN623ACViolich Farms Inc · Kentfield, CAN623BALmco · Vandenberg Afb, CAN628MCAir Methods LLC · Greenwood Village, CON629DFRojo Express LLC · Holland, MIN62GAFlagstaff Medical Center Inc · Flagstaff, AZ
Back to AD 2002-01-09