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.
N3397SMcrae Richard · Kent, WAN339DGRegistered aircraftN339MSMile And A Half High LLC · Sarasota, FLN33AGSory Bailey B IV · Bozeman, MTN33BBHendricks Timothy J · Telluride, CON33UT402wd Holdings LLC · Corpus Christi, TXN3422Hergenrather Michael · Spring, TXN342EAAfrican Inland Mission International · Peachtree City, GAN3432FBierschwale Land Co LLC · Mason, TXN344AJQualitair LLC Trustee · MichelstadtN345ALItm Aircraft LLC · Charleston, SCN346CBKombi Brazil Inc · Fort Lauderdale, FLN346RNSchroll Charles E · Tucson, AZN34BTWilliams Charles R · Wadsworth, OHN34FFZwierlein Victor · Grand Prairie, TXN34KBReilly Donald H · Micco, FLN34KFRsb Properties LLC · Lewes, DEN34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeN350GZValiair Lc Trustee · Casper, WYN350LCDaly Arthur P · El Paso, TXN350TMJefferies Stanley J · Coos Bay, ORN35443Registered aircraftN35498Ray Arthur G · Springdale, ARN354BSStevenson Bill · Sunrise Beach, TXN355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal noticeN355YPlussa Mark George · Clermont, FLN35677C3 Indutries LLC · Bakersfield, CAN35806Air Dakota Flite Inc · Hettinger, NDN35837Smernoff Michael J · Des Plaines, ILN35851Northwest Passage LLC · Anchorage, AKN35859Hooper Ranch LLC · Elko, NVN35868Spence Flight Service LLC · Enterprise, ORN35877Turbine Conversions Ltd · Nunica, MIN35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKN35889Torgerson Management Inc · Turtle Lake, WIN35909Flight1 Hsw LLC · Norwood, CON35932Tmzk Holdings LLC-1 · North Fort Myers, FLN35937Glaser Don E DBA · Willow, AKFirst renewal noticeN35945Illinois Department Of Transportation · Springfield, ILN35947Continental Construction Inc · Alpine, WYN35952Johnson Deborah K · Fairbanks, AKN35957Cortez Flying Service Inc · Cortez, CON35962Barker Aviation LLC · Spearfish, SDN359BDHoffman Brian T · Flower Mound, TXN359DACessna 359da LLC · Warsaw, VAN3605PSmith Bryan · Wenatchee, WAN360DLTorgerson Management Inc · Turtle Lake, WIN360MWMission Wings International Inc · Salem, OHN361DCSky West Aviation Inc Trustee · Albuquerque, NMN369HCCornerstone Mapping Inc · Roca, NE
Back to AD 2002-07-01