AD 75-18-06
Registered aircraft · 212
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-18-06')
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-18-06')
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-18-06') 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-18-06') 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.
N47HSJames David R · Wayne, MIN47MHWheatley Lester E Jr · Priest River, IDN47WFCantarini Cody M · Fallbrook, CAN47ZAGanuza Diego · North Miami Beach, FLN5162BK D Helicopters Inc · Shingleton, MIFirst renewal noticeN5167BStills Inc · Ashville, ALN5172BJames David R · Wayne, MIN547SBSequeira Michael J · Troy, MON555DScotts Helicopter Services Inc · Le Sueur, MNN555ENSetnar Stephen R · Butler, PAN568TBWhite Thomas J · Agua Dulce, CAN5990Aaa Aerial Solutions LLC · Dassel, MNN59HAircraft Sales LLC · Caledonia, MIN5HAmerican Helicopter Museum And Education Center · West Chester, PAN6140CNorth Coast Helicopter Service Inc · Napa, CAN6141Black Shadow Aviation Inc · Georgetown, FLN614ATBall Alexander R · Norco, CAN6173Whirlybirds LLC · Monroe, CTN617XDavis Lloyd L Jr · Brackettville, TXN61ARAircopters Of San Diego Inc · El Cajon, CAN62221Lundell Levi T · Bolling Afb, DCN6327DJohafe Aviation LLC · Wilmington, DEN63300Bassett Tommy J · Ashford, ALN6355Stewart Robert D · Farmington Hills, MIN6356Eagal Lloyd S · Renfrew, PAN6356XPleasant Aviation LLC · Mount Pleasant, TXN6359XKiob LLC · Lexington, KYN6520Henry Mark A · Dickinson, TXN6521Henry Mark A · Dickinson, TXN65520Sale Reported · Troy, MOSale reportedN6579DIxl Inc · Sulphur, LAN6597DHeli Flite Inc · Corona, CAN6707DMines Keith A · White Cloud, MIN6711DAnderson Christopher T · Janesville, WIN6720DNorthwind Hilos LLC · Schoolcraft, MIN6744DDyer Randall J · Frazier Park, CAN6749DCj Air LLC · Nezperce, IDN6750DMorten Jesse L · Larimore, NDN6758DCaruso Dennis · Saint Marys, PAN6774DSouthern Cross Aviation · Wilmington, DEN6776DMilam Inc · Trussville, ALN68GRMagnum Aviation LLC · Goff, KSN69GRMagnum Aviation LLC · Goff, KSN701GRMagnum Aviation LLC · Goff, KSN703GRMagnum Aviation LLC · Goff, KSN7081UHhi Farms LLC · Hamilton, MIN7137ZGreenway Michael D · Friday Harbor, WAN74004House Guy C · Castle Creek, NYN74005Newton Property Leasing LLC · Greene, IAN74081Kehoe Keith J · Marion, TX
Back to AD 75-18-06