AD 72-01-07
Registered aircraft · 1,150
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:72-01-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07')
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:72-01-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-01-07') 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.
N2445AMcmillian Dean R · Wasilla, AKN245KWCarson Cubs LLC · Yelm, WAN2461AGaller Mary D Trustee · Elysian, MNN246LDHoppe Nicholas J · Big Lake, AKN2474ZTeufel Jeffrey · North Pole, AKN247TGriffin Kenneth D · Anchorage, AKN2487AHoffman Gary D · Spencer, NEN2488APetrik Kale O · Sidney, MTN2489ALong Patrick B · Buffalo, WYN248TGiannonatti Lance A · Ludlow, SDN2491ACampbell Aviation Inc · Dutton, MTN2494AOtto Justin · Lakeland, TNN2496ASibille Keith C · Griffin, GAN2496PTri M LLC · Nikiski, AKN249TBigger Tires More Fun LLC · Anchorage, AKN24QBFedorko Daniel J · Saylorsburg, PAN250TWhite William Brian · Apex, NCN2510AIlgenfritz Don C Jr · Fairbanks, AKN2511ABrierley Michael G Trustee · Sparks, NVN2512AFell William P · Anchorage, AKN2514ABeard Michael Wayne · Eveleth, MNN2515AClaus Jay G · Palmer, AKN2516AAscension Aviation LLC · Gaylord, MIN2518ARegistration Pending · Wasilla, AKRegistration pendingN252TJanssen Jerry D · Barnesville, MNN2534AWilcoxon James · Scobey, MTN254TFindlay Harald · Charlotte, VTN256TPulkrabek David P · Hutchinson, MNN2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeN257TRegistration Pending · Pittsfield, MERegistration pendingN2581ASattler Philip J · River Falls, WIN2585ARipplinger Stephen M · Enderlin, NDN258TDiamond X LLC · Elko, NVN2621AFox Jeff R · Soldotna, AKN2625AGundersen James I · Townsend, MTN262TBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCN264TPm Aviation LLC · Missoula, MTN2660AN62689 Inc · Texarkana, TXN2666PBerentson Bradley J · Westhope, NDN267CMRegistered aircraftN2681AKatzmarek Clay M · Wasilla, AKN2683ALovett Andre D · Anchorage, AKN2684AMckinley I Blake Jr · Spokane Valley, WAN2688ALanham Rex E · Boise, IDN2689AWomack W A · Jackson, LAN268TCline David R · Maryville, TNN2695PDodge Alan J · Miles City, MTN269TCleveland Frank W · Quinhagak, AKN26VCAlbertson James M · Westville, FLN27036Pace William Todd · Palmer, AK
Back to AD 72-01-07