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.
N6207HYr-Aircraft Leasing LLC · Bethel, AKN6209C8 Waters LLC · Goodyear, AZN6209PFly Fast Live Slow LLC · Chiefland, FLN6211BFleming Patrick J Trustee · Palm Desert, CAN6214VRegistered aircraftN6218YLucky Star Auto Sales Inc · Grangeville, IDN621AKelsey John · Casa Grande, AZN6223BSpirek Aaron M · Henderson, NVN6227YWest Brook Group Inc · Pleasant Hill, IAN6229CClause James W Trustee · La Quinta, CAN6233ZMission Aviation Fellowship · Nampa, IDN6237YStrategic Sourcing Solutions Inc · Topeka, KSN6238UInland Crop Dusters Inc · Shafter, CAN6239YBlue Horizon Aviation LLC · New Concord, OHN6240BVan Treese Farms Inc · Monte Vista, CON6243CDcd Aircraft Sales LLC · Leesburg, FLN6243ZSeattle Seaplanes LLC · Seattle, WAN6246BR L Equipment And Services LLC · Monument, CON624DRRyan Air Inc · Anchorage, AKN624ERRyan Air Inc · Anchorage, AKN624MTJcct Holdings LLC · Plano, TXN6255HRenfro Michael W · Bethel, AKN625KWSchmoker William C · Eden Prairie, MNN6262KBrz Air LLC · Beaumont, TXN6266HNovi Inc · Ruby, AKN6267YZero Four Twelve LLC · Clovis, NMN626KTRustair Inc · Anchorage, AKN6270XLees Robert A II · Mesa, AZN6271BCountry Flyin Inc · Homestead, FLN6274AA V T210 LLC · Palmdale, CAN6276BN6276b LLC · Katy, TXN6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKN6278YTown & Country Aviation LLC · Sunnyvale, CAN627BTAviation Global Inc · Saint Augustine, FLN6280PAirborne Equipment Inc · Hendrum, MNN6282BBig G Air LLC · Durango, CON6285HWhitetail LLC · Anchorage, AKN628TTTollen Troy J · Austin, TXN628YTAdventist World Aviation · Wilson, NCN6290WLord Of The Wings LLC · Syracuse, NYN6291CSatl Ranch Aviation LLC · Midland, TXN6294PMarkowich Darren K · Gilbert, AZN6295YSkydoc LLC · Mokena, ILN6297HHackbart Gary H · Las Vegas, NVN6297YL&L Aviation LLC · Baden, PAN6299CCenturion Flight LLC · Auburn, WAN6299PDanlars Aircraft Sales · Mccall, IDN629WSPrecision Avionics Specialists · Griffin, GAN62SK55x LLC · Kalispell, MTN6300PSchrempp Aviation LLC · Winnemucca, NV
Back to AD 2002-07-01