AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N4769TBowsap LLC · Manson, WAN476ATAirmen Testing And Training Inc · Lantana, FLN476BCDavis Samuel C · Corona, CAN476CACivil Air Patrol · Maxwell Afb, ALN476CFHalderman Floyd G Jr · Eldon, MON476CMUniversity Of Central Missouri · Warrensburg, MON476DWSkylane Capital Group LLC · Seattle, WAN476EREmbry-Riddle Aeronautical University · Daytona Beach, FLN476EWWny Air Inc · Dover, DEN476FLHawkins Rebecca · Sandpoint, IDN476FMShumaker James B · Salinas, CAN476HDurbin Christopher J · Weirsdale, FLN476JHBills Helicopter Service LLC · Woodlawn, VAN476JWWiggins Jason · Albany, GAN476KETrexel Paul C · Willits, CAN476LSHoffman Anthony J Trustee · Hillsboro, ORN476MAAdamko Victor W · Riley, MIN476NHHeadings Norman D · Walnut, ILN476PCSaint Louis University · Saint Louis, MON476RBWilson Ricky A · Santa Teresa, NMN476RCNsp Air LLC · Saint Petersburg, FLN476SHT2 Aeronautical Service LLC · Corpus Christi, TXN476SMTail Slide Aviation LLC · Wilmington, DEN476SPChristiansen Aviation LLC · Wilmington, DEN476WBurkhard Daniel A · Vero Beach, FLN476WGTrow Michael P · Seattle, WAN47700Indian River Flying Club Inc · Rockledge, FLN47702Braudis Russell P · Pittsburg, TXN47705Tidona Robert J · Berwyn, PAN47706Coast 2 Coast LLC · Pensacola, FLN4770ARobinson Evan · Pasadena, CAN4770DNapier Michael D · Russell, KYN4770FHamblen Scott · Tucson, AZN4770KPaulk Charles Jr · Naples, FLN4770LIdol Joshua N · Boone, NCN4770SGuidry Derrick Jermaine · Lake Charles, LAN47711N47711 LLC · Sheridan, WYN47714Bradford Matthew Corin · Murrieta, CAN47718Ap Midway Inc · Palos Hills, ILN47719Webb Bennie Kenneth · Fitzgerald, GAN4771JAsx Flight Services LLC · Ashland, WIN4771KAshby Kenny · Mead, CON4771LHenderson Brian K · Redding, CAN4771ULoomis Rick A · Prescott, AZN47723Six Drew · Clinton, OHN4772ADodson International Parts Inc · Rantoul, KSN4772EDrost Larry L · Charlevoix, MIN4772LValiair Lc Trustee · Casper, WYN4772QHodgson John P · Atlanta, GAN4772RKimball Michael G · Placerville, CO
Back to AD 2007-04-19 R1