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.
N8706ZElliott Michael L · Raeford, NCN8710QMicro Tool Inc · Idaho Falls, IDFirst renewal noticeN8711ZNeff John Sr · Lumberton, TXN8715ZMarconi Joseph · Hamilton, OHN8719ZFedane Rohit · Green Bay, WIN8725QN8725q LLC · Grand Junction, CON8725ZRomine George · Tucson, AZN8727ZRobertson Reuben · Johnson City, TNN8731QHinlein Erich S · Pelham, MAN8732ZZiprik Russell L · Ball Ground, GAN8733ZTerway William · Wilsonville, ORN8734ZHardin Matthew W · Rutherford, CAN8735ZMcgarity Justin D · Paragould, ARN8736QCourtney Aviation LLC · Columbia, CAN8740QHampton Harvey E · Simms, MTN8753ZBloated Armadillo Adventures Corp · Wilmington, DEN8754QD2 Holdings LLC · Salt Lake City, UTN8754ZBwana Z Transporation LLC · Missoula, MTN8755QMartensen Marten · Anchorage, AKN8756QTriple 2 LLC · Burlington, CON8758QBerge Christian · Mccall, IDN8758ZBellows Paul F · Vancouver, WAN8759ZHelin Bruce A Trustee · Flagstaff, AZN8761ZHaag Walter G · Fall City, WAN8763QArtic Backcountry Flying Service LLC · Kotzebue, AKN8763ZMacdonald John R · Vancouver, WAN876R76r Holdings LLC · Rockport, TXN8773ZPolhamus Mark Trustee · Thompson Falls, MTN8774ZAero Squadron LLC · San Diego, CAN8775ZB&B Auto Body LLC · Terreton, IDN8781ZHogue Marc · Tempe, AZN8783ZAdventure Aircraft And Equipment LLC · Chelan, WAN8787Q2fly Safety LLC Trustee · Azle, TXN8787ZKing Farm Partnership · Mccrory, ARN8788QKochert Timothy B · Anchorage, AKN8789ZParrott Charles F · Saugus, MAFirst renewal noticeN8792ZPerkovich Brian T · Oneida, WIN8794ZJones Petroleum Co Inc · Jackson, GAN8795QWright Air Service Inc · Fairbanks, AKN8795ZNeuschaefer George H · White Hills, AZN8796QSpangler Robert E · Anchorage, AKN8797ZCjc Enterprises LLC · Erda, UTN8799ZMagnuson Robert L Jr · Mc Grath, AKN87MUUrdaneta Luis · Miramar, FLN87RWSunward Corp · Denver, CON8823HBowers Phillip P · Clayton, NCN8844GNorthside Logistics And Automotive Inc · Dardanelle, ARN886KHLexi Air LLC · Boise, IDN887PBZankiz Jose Carlos · Naples, FLN887WQuad City Area Flying Eagles Inc · Milan, IL
Back to AD 2002-07-01