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.
N32314Fort Dodge Flight Support Inc · Fort Dodge, IAN32318Feulner Lori · Hebron, NEN3231DMcfarlane Claude L · Fitchburg, WIN3231JNovember Alpha LLC · Dover, DEN3231QCollins Gregory J · Appleton, WIN3231RAll2fly LLC · Atlanta, GAN3231TGouse Frederick Earl II · Waxahachie, TXN3231WDouble F Enterprise LLC · Paullina, IAN3231ZWestern Skyways Inc · Montrose, CON32321Irvin Phillip Jerry · Winters, TXN32326Blair James J Jr · Brick, NJN3232WKilgallen Keith S · Stuart, FLN3232YWise Frederick W · Windsor, PAN32331Sowers Richard M · Reno, NVN32332Warrior 74 LLC · Columbia, SCN32334N32334 Aviation LLC · Chandler, AZN32336Simmer Nicholas Lee · Rock Falls, ILN32337Pab Air Inc · Hialeah, FLN32338Rivera Filiberto Jr · Moses Lake, WAN3233ESilver Star Helicopters LLC · El Campo, TXN3233FPlank Lester L · Montgomery, INN3233GMach Aviation Pilot Services LLC · Andover, KSN3233JZebcon Inc · Russellville, ARN3233LMann Aviation LLC · Wilmington, DEN3233MBoniek Martin J · Glennallen, AKN3233SVan Ness James A · Buckley, WAN3233WPickens Nathan A · Caldwell, IDN3233YShepperson Ranch Co · Midwest, WYN3233ZGelvin Stanley M · Central, AKN32344Cunningham James L · Oshkosh, WIN32346Voumard Rodney · Turlock, CAN3234FLastochka LLC · Kalispell, MTN3234PMccraw Samuel A · Cowpens, SCN3234YGrefsrud Travis · Pelican Rapids, MNN32351International Air Services Inc Trustee · Carson City, NVN32353Gardiner Kenneth W · Enfield, MEN32355Finlayson Duncan Robert · Estacada, ORN32357Malone Bernard G · Frenchtown, NJN3235BHbhis LLC · Gnadenhutten, OHN3235DMdb Ventures LLC · Wausau, WIN3235FRosario Michael J · Memphis, TNN3235SPollard Brent H · Wilburton, OKN3235TBhatia Kabir · Lake Oswego, ORN32361Odom Eric J · Johnson City, TNN32363Wagner Daniel R · Dewey, AZN32364Buffalo Ridge Aviation LLC · White, SDN32367Martin Stephen · Bonney Lake, WAN32369Avia Flight Academy LLC · Stratford, CTN3236DFrey Joseph · Fallon, NVN3236PFalcon Air LLC · Anchorage, AK
Back to AD 2007-04-19 R1