AD 48-07-01
Registered aircraft · 2,265
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:48-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-07-01')
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:48-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-07-01') 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.
N1790VThompson Randy L · Anderson, CAN1791NKieser Jason P · Bloomington, ILN1792VScholz Paul W · Clifton Park, NYN1793NDaigh Eric B · Ketchum, IDN1794NRedsun Oren D · Fairfield, CAN1795NBeckham Joseph D · New Waverly, TXN1797NStrebel David P · Oroville, CAN1797VValle Perez Kevin · Castroville, TXN1798NHissam Joshua K · Pasco, WAN1798VBolton Derwin B · Jacksonville, TXN1803VAnderson Michael J · Carmichael, CAN1805NThompson Randy L · Anderson, CAN1806VBrown Christopher · Mancelona, MIN1807VBushre David N · Janesville, WIN1808VReller Bernard D · Gainesville, FLN1810NMetzler Darwin H · Manheim, PAN1812NRutherford Kevin · Sheridan, ARN1813VCodingflyboy LLC · Hayward, CAN1817VHarper James J · Miller, MON1818NFirth Thomas H IV · Sonora, CAN1819NPower Terry Edward · Council, IDN1819VSparebanc LLC · Appleton, MNN1823NMoehn Dennis H · Oshkosh, WIN1823VWeller Oscar R · Sun City, AZN1826NHenry Dean R · Gilroy, CAN1827NBrooks Adam Jacob Robert · Granada Hills, CAN1827VAgate Mark A · Phoenix, AZN1829NEvans Earl J · Oglethorpe, GAN1829VJacob Mark K · East Lansing, MIN1834NBernard Elswick Theodore · Fernley, NVN1835VHauser Linda L · Ulysses, KSN1836NMulligan Kevin S · Port Alexander, AKN1838NMutual Flyers Inc · Columbus, NEN1838VRegistered aircraftN1839VEdwards Christopher V · Seattle, WAN1840NBybee James W · West Jordan, UTN1843NMaples Andrew L · Belle, MON1843VFrostman Ronald G · Ft Myers, FLN1844NCorn Dustin M · Muncie, INN1844VWheelock Jon M · Fairbanks, AKN1845NLoucks Donald A · Bastrop, TXN1847NO'Quinn Aaron N · Anchorage, AKN1848VGray William G · Littlefork, MNN1849VCooke Patrick E · Wrightsville, PAN1850VHudson Dave C Jr · Sumrall, MSN1851VKraemer Norma J · Deadwood, SDN1853NProst Gary E · Stockton, CAN1853VMid Michigan Aviation LLC · Owosso, MIN1856CJones Mark S · Tampa, FLN1858NWeeks Addison W · Covina, CA
Back to AD 48-07-01