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.
N2867YCook Kevin M · Hallettsville, TXN28682Mcclure Glenn E · Convoy, OHN28683Siry Steven · Santa Barbara, CAN28684Loveless Anesthesia Pllc · Conway, ARN28688Jennings Jared Alan · Tacoma, WAN2868ATaylor Eric C · Port Townsend, WAN2868DMayer Larry A · Billings, MTN2868FKilduff Transportation LLC · New River, AZN2868KMyers Mark D · Anchorage, AKN2868MEngler Eric M DBA · Cass City, MIN2868PRedman Adam J · Anchorage, AKN2868QRutherford Services Inc · Plains, PAN2868TBooth Gregory · Ferriday, LAFirst renewal noticeN2868WExecutive Flight Institute LLC · Murrieta, CAN2868YMobile Dev Group LLC · Fair Lawn, NJN28692Heidi'S House LLC · Woodstock, GAN28693Velocity Air LLC · Lebanon, TNN28696Clark Brian David · Cumming, GAN28697Saddler Harry · Berkeley, CAN28699Mizner Michael D · Richfield, UTN2869PAlaska Aviation Museum · Anchorage, AKN2869QDurnall Daniel J · Sonora, CAN2869RDiehl Steven L · Martinsburg, PAN2869TBoone Susan J · Bastrop, TXN2869UDavis Isabelle L · Mason, NHN2869YDurand Russell Gene · Luthersville, GAN2869ZRolling Rock Equipment LLC · Mount Pleasant, PAN286AKDog Island Air Inc · Wilmington, DEN286BGD&J Aviation LLC · Apopka, FLN286CHammond John Henry · Gunnison, UTN286CMB&K Aircraft Leasing LLC · West Plains, MON286DSGj Star LLC · Marquette, MIN286GRGinal Ronald T DBA · Essex Junction, VTN286JAMungo Air LLC · Saint Louis, MON286JKC & N Aviation LLC · Anaconda, MTN286LHSolace Aviation LLC · Atglen, PAN286NDMorris Randall Sanford Hartnett · Fort Worth, TXN286PASkywest Leasing Inc · St George, UTN286PSRocky Mountain Airsports LLC · Salida, CON286QPagni Peter P · Anchorage, AKN286TCJb Aviation LLC · Waxahachie, TXN286WSchlutz Greg F · Longmont, CON286WYWos Holdings III LLC · Belgrade, MTN286YMBug Smasher LLC · Mitchell, SDN28703Barney Diane J · Mojave, CAN28705S & M Aviation Inc · Barefoot Beach, FLN28706Kalus Joseph G · Afton, WYN28708Camacho David P · Macon, NCN2870DBardsley Lucas A · Sutton, AKN2870TDohrenwend Michael P · Huntsville, AL
Back to AD 2007-04-19 R1