AD 76-07-07
Registered aircraft · 496
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:76-07-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:76-07-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:76-07-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:76-07-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.
N421KGWhite 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, MTN421TFIntrepid Enterprises LLC · Wichita, KSN421TGRegistered aircraftN421TPDouble R Aviation LLC · Reno, NVN421TTEnvision Ventures LLC · Williston, NDN421TVYuba City Solar Millennium Fund LLC · Rocklin, CAN421TXHolly Factory · Alachua, FLN421UTR&C Welding And Fabrication Inc · Gering, NEN421VHead Rest Ltd LLC · Las Vegas, NV
Back to AD 76-07-07