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.
N756WRReinbold Frederick K · Anchorage, AKN756XEKachemak Air Service LLC · Homer, AKN756XYArizona Air Salvage · Phoenix, AZN756YCMb Aviation LLC · Ridgefield, WAN756YDGarza Aircraft Inc · Harlingen, TXN756YHGroundhog Mining And Milling Co LLC · Dillon, MTN756YSShoreline Consulting · Bryan, TXN756ZHHeartland Aviation Inc · Alliance, NEN756ZVSmokey Bay Air Inc · Homer, AKN7576NHusum Charles · Redmond, WAN75773Dena'Ina Leasing Agency LLC · Anchorage, AKN7584NCarto Flight Inc · Willoughby, OHN75870Westwind Aviation Inc · Phoenix, AZN758FCapital Aircraft LLC · Juneau, AKN7590NIventosch Leonard · Mccall, IDN7591NJones Michael D · Southern Pines, NCN75935Allison Aviation LLC · Missoula, MTN7594MNcneill Dudley · Happy, TXN7598ZCivil Air Patrol Inc · Maxwell Afb, ALN7599NAir Conejos Inc · El Paso, TXN75DAHenderson John L · Ozona, TXN75DKPaul Mark A · Warren, OHN75DMPro-Rentals Inc · Athens, OHN75EELgc Consulting Inc · Salisbury, NCN75GLSkyshare LLC · Boulder, CON75LGMarr Lance · Portland, ORN75PJJohnson Peter G · Tower, MNN75RCJoffe Zalman · Bahama, NCN75VRSlt Global Alliances LLC · Las Vegas, NVN75WFSjs Holdings LLC · Los Angeles, CAN7600NKeller Douglas O · West Linn, ORN7605URyan Air Inc · Anchorage, AKN7610CSawtooth Flying Service Inc · Mccall, IDN7610MEickhoff Steven M · Fountain, MNN7615NHelms Aviation Inc · Long Lake, NYN761AGChalk 2 Inc · Apple Valley, CAN761AKHub Properties Ltd · Wilmington, DEN761ALPacific Valley Aviation Inc · Arbuckle, CAN761AMGood Enuf LLC · Wilmington, DEN761ANWinger Cattle Company Inc · Johnson, KSN761AQOrangesocks Aviation LLC · Chesterland, OHN761BDRockwell Richard E · Aledo, TXN761BEAnderson Kristian L · Albuquerque, NMN761BLLong Ernest D · Trabuco Canyon, CAN761BVN761bv LLC · Sioux Falls, SDN761BYB&E Leasing LLC · Dubuque, IAN761BZAltair Aircraft LLC · Gainesville, FLN761CECharlie Echo Enterprises LLC · Cedar Hills, UTN761CLUlrick Michael R · Spokane, WAN761CNFrance Sherrod W Trustee · Rawlins, WY
Back to AD 2002-07-01