AD 75-01-07
Registered aircraft · 2,118
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:75-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:75-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:75-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:75-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.
N2020WMidland Mist Inc · Midland, GAN2021EEagle Home Medical Corp · Roanoke Rapids, NCN20224Obie Aviation LLC · Rogers, ARN2022WStadelmann Joseph P · Milton, MAN2024GPerry Scott D · Hood River, ORN2024KB2s Aviation LLC · Billings, MTN2024VWhiskey Tango Flyers Inc · Middletown, DEN2024WMunn Jeffrey R · Auburn, NYN2028AWallender Timothy J · Manhattan Beach, CAN2028PFerm Michael D · Fort Calhoun, NEN2029DVictory Auto Sales LLC · Memphis, TNFirst renewal noticeN202JRiche Aviation LLC · Baton Rouge, LAN20307N20307 LLC · Trabuco Canyon, CAN20318Siegfried Thelma Trustee · Downers Grove, ILN2032EOhio Air Partners LLC · Chardon, OHN2035PHubert John P · Austin, TXN2037WGregs Crop Care Co · Wilbur, WAN2038UWorld Aero Space Ltd · Henderson, NCN203PLHhj & Rbj Holdings LLC · Prattville, ALN2040ASchultz Philip W · Lancaster, CAN2040PTrb Aviation LLC · Fredericksburg, VAN2040YCappel Eric H · Satellite Beach, FLN2041WJimenez John D · San Antonio, TXN2042BHasemann James M · Gaithersburg, MDN20478V35b Bonanza LLC · Temecula, CAN2047WKapusta Marian · Clearwater, FLN2048WTripi Mark DBA · Parkersburg, WVN2049NAdvanced Aviation LLC · New Century, KSN2049WHufford P Thomas Trustee · San Diego, CAN2050ZPong William Robert · San Mateo, CAN2051KSocio Aviation Services LLC · Benton, KYN2053WOem Products Inc · Oklahoma City, OKN2054NHampton Todd J · Plainfield, INN2054WVerran Clinton T · Rochester Hills, MIN2055UR & D Aircraft LLC · Port Orange, FLN20572Shaw Brian · Meadville, PAN2058WSweet Fred A · Loves Park, ILN2059ABuerge Scott · Nevada, MON2059WMorgan Jeffrey B · Edgewater, FLN205PMHochstetler Allen D · Fairfield, CAN20603Burlington Air Center Inc · Burlington, WIN2060WBreskman David G · King Of Prussia, PAN2062BWalker Marshall E · Lancaster, SCN2062WMichalka James R · Portage, MIN20654Spatz Phillip D · League City, TXN2065YAbel Instruments Inc · Riviera Beach, FLN2066NBobo Kenneth · Auburndale, FLN2072WNewsome Jeff · Blackwell, OKN2073WPlowden William E Jr · Shelby, NCN2075WCooper Jeffrey B · Eagle River, AK
Back to AD 75-01-07