AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N4696FTorres Roberto · Bavamon, PRN4696K96 Kilo LLC · Modesto, CAN4696LKoontz Marina M · Seattle, WAN4696XAval Aviation LLC · Las Vegas, NVN4697GVeety Roy D · Dalton, PAN4697KMorgan James D · Denali Park, AKN4697LTverberg Justin T · Omak, WAN4697NWang Kun · Whitestone, NYN4698C98 Charlie LLC · Anchorage, AKN4698DDrm Aviation LLC · Glencoe, ALN4698KRegistered aircraftN4699AReed Aviation LLC · Pearl, MSN4699FStinson Ryan · Eagle, IDN4699UValdez David M · Shady Shores, TXN4699WN4699w LLC · Rutherford, CAN469DCLaw David L · Derby, KSN469DTBarr Air Patrol LLC · Mesquite, TXN469ERMaxxum Financial Group Inc · Destrehan, LAN469FGMustang Sally Aviation LLC · Camden, SCN469MBFloriflt LLC · Daytona Beach, FLN469MHWhat Could Go Wrong LLC · Murfreesboro, TNN469NETauber Samara R · La Jolla, CAFirst renewal noticeN469TCEast Pole Aviation LLC · E Setauket, NYN46AMDuffy Kevin · Manchester Center, VTN46BCHfc Inc · Halma, MNN46CAEnglehart James C · Marietta, GAN46EFPringle Dan · Charlestown, INN46FFFf22 LLC · Scottsdale, AZN46GMDeffner Gerhard Paul Heinrich · Mckinney, TXN46JFTisdell Michael S · Olivia, MNN46JWWerner John D · Pownal, VTN46MPAnderson Howard E · Luray, VAN46MRDavin Matthew · Ridgecrest, CAN46PCMace Robert C Jr · Gold Canyon, AZN46PGRegistered aircraftN46PKTensas Taildraggers LLC · Saint Joseph, LAN4700FAssociated Equip Representatives Inc · Yakima, WAN4700XCerasia Steven S · Amsterdam, NYN4701DMiller Larry L · Dade City, FLN4701QWindsor Greg A · Anchorage, AKN4701URegistered aircraftN4702FSouthern Aces LLC · Geneva, FLN4702KUniversity Auto Sales Inc · Pell City, ALN4702QDriggs Daniel H · Anchorage, AKN4702WFour Flying Fools LLC · Geneva, FLN4703KSkeffington Robert C · Topsfield, MAN4704ABrown Helicopter Inc · Pensacola, FLN4704CWright Brian A · Nampa, IDN4704GRegistration Pending · Spencerville, OHRegistration pendingN4704NScott Lester N · Pleasanton, CAFirst renewal notice
Back to AD 79-10-14 R1