AD 56-01-01
Registered aircraft · 152
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:56-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-01-01')
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:56-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-01-01') 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.
N300JGBamford Virginia J · Woodside, CAN3105GClassic Rotors Museum · Ramona, CAN33507Gooney Bird Group Inc Non Profit Corp · Templeton, CAN3358FPietron Chad D · Larimore, NDN368GRBetsi Bell Inc · Jacksonville, ARN3740GSkypro · Jacksonville, FLN3755JSpinney Jeffrey James · Flushing, MIN405HHGuardian Aviation LLC · Lakeland, FLN4115ADobalian Vaughn E · Jacksonville Beach, FLN415DPAntique Airlift LLC · Mokena, ILN440TGScotts Helicopter Service Inc · Lesueur, MNN4419ERatledge Thomas D · Bethel, AKN4423Matthews Kenneth R · Santo, TXN4427PPike Mark D · Victorville, CAN444EHJohafe Aviation LLC · Wilmington, DEN4550WNewton Property Leasing LLC · Greene, IAN470SBMidwest Choppers LLC · Colman, SDN471BHRocky Mount LLC · Kalispell, MTN472DMMcdowell David M · El Cajon, CAN472GDDunn Gary M · Galesburg, MIN4771ZScotts Helicopter Service Inc · Le Sueur, MNN4774CScotts Helicopter Service Inc · Le Sueur, MNN47CSTropicalproperties LLC · Lewes, DEN47EDCornerstone Financial Enterprises LLC · Mesquite, NVN47GQMccoy Robert M · Barksdale, TXN47HSJames David R · Wayne, MIN47MHWheatley Lester E Jr · Priest River, IDN47ZAGanuza 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, MNN568TBWhite Thomas J · Agua Dulce, CAN5990Aaa Aerial Solutions LLC · Dassel, MNN59HAircraft Sales LLC · Caledonia, MIN6140CNorth 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, DEN6355Stewart Robert D · Farmington Hills, MIN6356Eagal Lloyd S · Renfrew, PAN6356XPleasant Aviation LLC · Mount Pleasant, TXN6359XKiob LLC · Lexington, KYN65520Sale Reported · Troy, MOSale reportedN6597DHeli Flite Inc · Corona, CA
Back to AD 56-01-01