AD 75-06-01
Registered aircraft · 2,832
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-06-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:75-06-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:75-06-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:75-06-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.
N3216KSouth River Services LLC · Myrtle Beach, SCN321CWBatte Bennie S · Forest, MSN321CYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN321FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN321HXGggg LLC · Hilton Head Island, SCN321PDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN322N322 LLC · North Las Vegas, NVN3220LPee Dee Aviation LLC · Florence, SCN3221MGuardian Flight LLC · Lewisville, TXN322HGH & O Aviation LLC · Oxford, MSN322MRPf Aircraft LLC · Graham, TXN322MTSkyak LLC · Chanhassen, MNN322WWWest Aviation LLC · Palm City, FLN3246SInsync Investments LLC · Dover, DEN3247BSlowflight LLC · Wilmington, DEN324WRenshi LLC · Palm City, FLN3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeN325BMFarm Air Service Inc · Tallulah, LAN325PWWatson 321 Air LLC · Flower Mound, TXN3262REaglemed LLC · Wichita, KSN3263CEaglemed LLC · Wichita, KSN3263NGuardian Flight LLC · Lewisville, TXN326CAAlpine Aviation Inc · Provo, UTN326KWBering Air Inc · Nome, AKN327BGGrimsley Aviation LLC · Dallas, TXN327MJTour Aviation LLC · Naples, FLN327MZWdl/Oracle LLC · Tucson, AZN327RHealth Care Capital Of North Carolina LLC · Atlanta, GAN327SFState Of Colorado · Lakewood, CON32973Crop Jet Aviation LLC · Gooding, IDN3299KJones Aviation Inc · Biggs, CAN3299PAir Care Leasing LLC · Lamar, CON329ATAirtrex Registration Corp Trustee · Wichita, KSN329GSAugusta Aviation Inc · Hilton Head Island, SCN329MMRuegg Aircraft Holdings LLC · Wilmington, NCN32CARegistration Pending · Fairbury, NERegistration pendingN32GWGreat Western Aviation LLC · Seattle, WAN32PDynamic Avlease Inc · Bridgewater, VAN330AVUas Transervices Inc · Boca Raton, FLN330DBBlueskyways LLC · Bend, ORN331JPSfh Inc DBA · Fargo, NDN331KECrop Air LLC · Eaton, CON332ATAg Solutions LLC · Satanta, KSN332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCN333KKHocken Brett Trustee · Lake Oswego, ORN333MLSeneca Flight Group LLC · Clearwater, FLN333QTQ Flight LLC · Bernardsville, NJN333XPRichard L Richards Pa Trustee · Coral Gables, FLN333XXArnot Robert · Stowe, VTN3356YAdvanced Aviation Services LLC · Sheridan, WY
Back to AD 75-06-01