AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N405FAWestosha Flying Club Inc · Kenosha, WIN405FDQualitair LLC Trustee · MichelstadtN405FLRiggin Flight Service Inc · Madison, SDN405JHTss Flying Club Inc · Bethesda, MDN405KCS H S Corporation · Indianola, IAN405KYSchnabel Jeffrey L · Villa Hills, KYN405MAHigh Ways LLC · Colorado Springs, CON405MHCall One Inc · Clarinda, IAN405NDSmith Michael Christopher · Concord, NCN405NRGasper Daniel C · Tacoma, WAN405PHFlap-Air Helicopter Service Inc · Canadian, TXN405RBOwens Aviation LLC · Elm City, NCN405RRBjp Aviation LLC · Seattle, WAN405RVNorberg Robert J · Las Vegas, NVN405SGriffing Flying Service Inc · Port Clinton, OHN405SBSky Bright Inc · Gilford, NHN405SPEastern Cincinnati Aviation Inc · Batavia, OHN405THNewgren Steven A · Kasilof, AKN405TSRichard N Appling · Ellensburg, WAN405WFVan Bortel Aircraft Inc · Arlington, TXN405XStover Lance E · Eden Prairie, MNN4060FJones Brent M · Las Vegas, NVN4060LBentley Aviation Services LLC · Lewes, DEN4060XTroyer Randy · Goshen, INN40614Marcotte Stuart E · Soldotna, AKN4061DDavis Russell C · Bakersfield, CAN4061MKrupinski Floyd M · Chugiak, AKN4061NChristensen Kier · Scottsdale, AZN4061SHammerstrand John A · La Mesa, CAN4061XCorriveaw Florian J · Whitefield, NHN4061YRegistered aircraftN4061ZJones Michael D · Eagle River, AKN4062ACessna 310n4062a LLC · Tuscaloosa, ALN4062DJohnson Gunnar W · Unalakleet, AKN4062EReimler Dan T · Rozet, WYN4062PLgop LLC · Maple Grove, MNN4063DRicheson Rodney Scott · Moses Lake, WAN4063QThin Air Inc · Hays, KSN4063XMellon Matthew J · Boone, NCN4063ZDenton Bobby L · Las Animas, COFirst renewal noticeN4064GLanyi Clifford M · Attleboro, MAN4064PVali Air Service LLC · Livingston, MTN4064XMtsh Aviation LLC · Wichita Falls, TXN4065529 Uniform LLC · Nashville, TNN4065BTaylor Mitchell · Lodi, CAN4065EKubat Wayne DBA · Wasilla, AKN4065SAlpha 3 LLC · Newcastle, OKN4066BKuipers Abram B · Derby, KSN4066ENelson Flyers Inc · Louise, TXN40670Cavorite Aviation LLC · Lehi, UT
Back to AD 2007-04-19 R1