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.
N434LQualitair LLC Trustee · MichelstadtN4366WPrentice Chris · Independence, ORN436EButcher Gregory E · Pensacola, FLN436JB700p LLC · Lewes, DEN4376WSmith Ryan · Canby, ORN437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIN4388WNiezen Henry J · San Luis Obispo, CAN438TBluhm Raymond M · Waxhaw, NCN4405AJohnson Marvin E · Garfield, WAN440DDeeble Kenneth M · Dayton, MTN440GVon Pasecky Ronald · Gilbert, AZN440QB&T Aviation LLC · Columbia, SCN4418ABorchert Pete · Prescott, AZN4419AMccants Robley D · Mesa, AZN4427WRockwall LLC · Wye Mills, MDN4430WMagerit Aviation Inc · South Boston, MAN4431WUnited Roofing Of Central Florida Inc · Ocala, FLN4432ABrown David L · Gold Hill, NCN4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeN4444KSivyllis Costas · Port Orange, FLFirst renewal noticeN444AFContinental Aero Associates Inc · Grosse Pointe Park, MIN444DGSwanson Douglas A · Marana, AZN444DKPiggott Russell T · Fresno, CAN444DWTriple 4 Dw LLC · Davie, FLN444RUFitzgerald Paul · Grapevine, TXN444TCHalstead Land & Cattle Inc · Arnold, NEN444WRNuccio Jeffrey W Trustee · Signal Mountain, TNN4452WHubbard Mark A · Wilmington, DEN4457SRegistered aircraftN4458ARaimondi Johann I · Doral, FLN4466SRegistration Pending · West Monroe, LARegistration pendingN4468WBorth John D · Meade, KSN446RDwons Roland Joseph · Oro Valley, AZN446TThatcher James W · La Canada Flt, CAN4470SFreitag Don M · Manhattan Beach, CAN4479SN4479s LLC · Nashville, TNN4484WRegistered aircraftN4485SDickerson Stephen Sr · Frisco, TXN4486SPopadich Nicholas · Monroe, MIN4486WReynolds Eric Eugene · Weatherford, TXN448JDavenport James A · San Antonio, TXN4493SRudrud David O Trustee · Scottsdale, AZN4494WConlon James E Jr · Troy, NYN4496SHme Holdings Group LLC · Franklin, INN449TSmallwood David · Oak Ridge, TNN44CMRussell Stephen J · Chester, VTN44PBMcpeck Adam S · Agar, SDFirst renewal noticeN4506SBaghs LLC · Fort Lauderdale, FLN4528SMoore William W · Merritt Island, FLN4529MMetzler Aaron · Otis, CO
Back to AD 75-01-07