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.
N8474UBirdwin LLC · Buras, LAN8475MSpess Drilling Co Inc · Cleveland, OKN84777Flight Path Partners LLC · San Mateo, CAN8477QShoshone Aviation Services LLC · Missoula, MTN8479QLake Airways Management LLC · Hazelhurst, WIN8482QGregg Flying Service Inc · Durango, CON8491QDry Bay Holdings LLC · Yakutat, AKN8495MCourtney Aviation LLC · Columbia, CAN8496QWord Forrest R Trustee · New Braunfels, TXN84SJLabelle Gregory D Trustee · Newbury Park, CAN8506QBell Robert C · Colby, KSN8514QAvila Robert A · Lawrence, MAN8523QLifetime Adventures LLC · Bellevue, MIN8526QKenworthy Winston C · Odessa, TXN852SDauenhauer Manufacturing Inc · Ketchum, IDN8546QBlack Andrew J · Broomfield, CON8560QLunati Ralph · Mc Alpin, FLN8564QEnvii Aviation LLC · Monroe, WAN8570QTwo O Six Inc · Fort Myers, FLN8576QThompson Robert Lee · Moore, OKN8580QBald Eagle Aviation LLC · Oakley, UTN858BBEchelon Group Inc · Boise, IDN858JAAms Aviation LLC · South Bend, INN8592QSkyview Aviation Holdings LLC · The Hills, TXN8594QParkerson Stan L · Fairbanks, AKN8598QTolley Samuel M · Rangely, CON8599QForbes Paul J · Anchorage, AKN859ALAms Aviation LLC · South Bend, INN85ADEagle Eye Produce Inc · Idaho Falls, IDN85PEMidwest Airmotive Inc · Mount Sterling, KYN8623ZHauze John W · San Antonio, TXN8628ZSaddler Susan J · Dayton, OHN8630ZAlaska Village Missions · Homer, AKN8632ZTate Roger · Redlands, CAN8635ZLipper Stephen W · Griffin, GAFirst renewal noticeN8638ZEichman David A · Topeka, KSN8643ZVitatoe Industries Inc · Chillicothe, OHN8644ZMasters Mission · Nenana, AKN8646QPoe Asphalt Paving Inc · Lewiston, IDN8647QTechnical Applications & Consulting LLC · Topeka, KSN8650ZBarry Russell L · Fort Mohave, AZN8674ZHoch Lance M · Weiser, IDN8686QWaters & Associates Inc · Bellaire, TXN8688ZPowell Leo · Villa Park, CAN8699ZEdaero LLC · Bangor, MEN86AGGarlow Terry J · Granbury, TXN86DHHolloway'S Tire And Auto Service Inc · Thomaston, GAN86MTWhite Knuckles Aviation LLC · Carson City, NVN8703ZLynch Cody Ryan · Galveston, TXN8704ZHunt David H · Ortonville, MI
Back to AD 2002-07-01