AD 95-09-13
Registered aircraft · 1,061
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:95-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:95-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:95-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:95-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.
N421JJSky Chariot LLC · Shafter, CAN421JLWagner Distributing Co Inc · Auburn, CAN421JNN421jn Aviation LLC · Wichita Falls, TXN421JPKiser Aviation LLC · Las Vegas, NVN421JR421jr LLC · Wichita, KSN421JSBank Of Utah Trustee · Salt Lake City, UTN421JTPetty Flying Service Inc · Munday, TXN421JWWheels Up Aviation LLC · Edmond, OKN421KGWhite Star Aviation LLC · Wilmington, NCN421KMWeatherproof Montana LLC · Missoula, MTN421LCampbell Inc · Williamston, SCN421LAChristensen Aaron M · Rapid City, SDN421LCApi Aviation Leasing LLC · North Venice, FLN421LEN421le LLC · High Springs, FLN421LFHaynes Aviation LLC · Caruthersville, MON421LG421cm LLC · N Charleston, SCN421LHCreel Skies LLC · Myrtle Beach, SCN421LKParadise Flyers LLC · Summerland Key, FLN421LLWhirlybird Aviation LLC · Bend, ORN421LQApex A & K LLC · Englewood, FLN421LYMayes John S · Austin, TXN421MBIowa Trenchless LLC · Panora, IAN421MDBoss Contract Services LLC · Terry, MTN421MEMeisner Aircraft Inc · Janesville, WIN421MFGti Leasing LLC · Atlanta, GAN421MGCowtown Aviation LLC · Hastings, NEN421MLLps Utilities Inc DBA · Woodstock, ILN421MUN421mu LLC · Missoula, MTN421NGUltimate Airparts LLC · Strasburg, VAFirst renewal noticeN421NLBas Part Sales LLC · Greeley, CON421PDesert Aerostar LLC · Scottsdale, AZN421PAPenley Steven A · Corinth, TXN421PLBdy LLC · Winter Park, FLN421PRPersonal Air LLC · Wilmington, DEN421PSAlways Five Oclock LLC · Laguna Hills, CAN421QGolden Eagle Aviation LLC · Wilmington, DEN421RAD & A Inc · Manhattan, KSN421RGZulu Forty One LLC · Anchorage, AKN421RJGreat Trends LLC · Phoenix, AZN421RNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN421RPXmountain Holdings LLC · Ada, MIN421SBBusch Leasing LLC · Holland, OHN421SFMidwest Drywall Co Inc · Wichita, KSN421SRWing Aero LLC · Dover, DEN421SSFarkas Tibor W · Georgetown, TXN421STZelta Air LLC · Nutley, NJN421TAQualitair LLC Trustee · MichelstadtN421TCAthar Glenola LLC · Mars, PAN421TDPerformance Aviation LLC · Novi, MIN421TETorgerson'S LLC · Ethridge, MT
Back to AD 95-09-13