AD 75-09-13
Registered aircraft · 4,787
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-09-13')
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-09-13')
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-09-13') 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-09-13') 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.
N3HKInternational Air Services Inc Trustee · Carson City, NVN3KKKraussman Daniel J · San Antonio, TXN3KPAllied Asset Management LLC · Oklahoma City, OKN3LNAllen Jeffrey W · Crestwood, KYN3QASg&F LLC · Riverside, CAN3UCYahraus Andrew · Phoenix, AZN3VACook Marvin R · Portales, NMN3VBHarrison Ted W · Grapevine, TXN3WFFolk Wolfgang · Fairfield, CAN400APZoie Air LLC · Fort Lauderdale, FLN400BJAirrich LLC · Largo, FLN400GMN400gm LLC · Salisbury, MDN400WTArtspret Aviation LLC · Sugar Grove, ILN401AZTre Aviation Corp · Wilmington, DEN401CAGlenn Roger H · Pacifica, CAN401KN401k LLC · Lonoke, ARN401MPFriend Ships · Lake Charles, LAN401MROk Av8r LLC · Iowa Park, TXN401RSTraining Services Inc DBA · Virginia Beach, VAN401SXHyannis Air Service Inc · Hyannis, MAN401TJHyannis Air Service Inc · Hyannis, MAN401WMMrd Aero LLC · Manheim, PAN402AJ2lyons Enterprises LLC · Wellington, FLN402BFSnell Marion Lea · Ackerly, TXN402BKN402bk LLC · Nantucket, MAN402CENorth American Aerial Surveys LLC · Tucson, AZN402CZEmission-Air Inc · Welcome, NCN402DZSamadi Jamshid · Leesburg, VAN402HGHyannis Air Service Inc DBA · Hyannis, MAN402JHAir Flight Inc · Fort Lauderdale, FLN402NKKhan Pervez · Miami Springs, FLN402PAAir Flight Inc · Fort Lauderdale, FLN402RSTropical Transport Services Ltd · San Jaun, PRN402SAAlly Mohamed Yacoob · Fort Lauderdale, FLN402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedN402VNHyannis Air Service Inc · Hyannis, MAN402WWPark Avenue Group Inc · Stuart, FLN402ZKAirplane One LLC · Miami Springs, FLN4032CKrs Aerial Inc · Galloway, OHN403AJAero Jet Aviation I Inc · Fort Lauderdale, FLN403RMUlpiano Amy L · Carolina, PRN403SWheeler James · Shreveport, LAN4043GGalaxy Aviation Services LLC · Orlando, FLN404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404DGSubgup LLC · Naples, FLN404NEFehlhaber Wolfgang M · Port Orange, FLN404NSJ + D Aviation Services LLC · Centerville, MAN404PJPrivate Jet LLC · Miami Springs, FLN4051CSky High Ventures LLC · Bartlett, TNN4057CAberdeen Flying Service · Aberdeen, SD
Back to AD 75-09-13