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.
N1859VKorson James J · Yorkville, ILN1860VNuckles Charles A Jr · Suffolk, VAN1863VSouthern Aircraft Consultancy Inc Trustee · Casper, WYN1866NSpivey Darwyn D · Guntersville, ALN1867NPasqualino Mark W · Ocala, FLN1872VPlane Fun Inc Tr Trustee · Snellville, GAN1873NBarbee Max C · Wharton, TXN1874NCuddie Robert R · Marble Falls, TXN1874VRaczynski Adam · Far Rockaway, NYN1875VTigger LLC · Missoula, MTN1877NAscolese Michael J · Athol, MAN1877VHickman Robert J · Canby, ORN1879VAnderson Marshall C · Jacobson, MNN1881VSimonson Todd D · Minnetonka, MNN1882VBell William F · Peachtree Corners, GAN1883NStrand Stephen E · Pelican Rapids, MNN1888NMorton William J · Hurst, TXN1888VMiller Thomas Lee · Clemmons, NCN1890NVasquez Allison O · San Antonio, TXN1891NMcmaster James R II · Bath, PAN1894NWarren C Metzger II · Anchorage, AKN1894VKohlert Jeffrey R · Saint Charles, ILN1895VMontgomery Larry G · Seymour, INFirst renewal noticeN1897NNasw Foundation · Rio Grande, NJN1901NHowerton Bradley S · Bartlesville, OKN1903VCovelli Rene A · Cherry Hill, NJN1906NBourland Alton L · Santa Teresa, NMN1907VChristopher Russell L · Leona Valley, CAN1909NSanders David L · Powell, WYN1910VBommarito Sterling J · Bend, ORN1912VWatson Bryan · Kent, WAN1916VSuter William A · Bluffton, OHN1917NLozano Brian · Santa Rosa, CAN1917VJustice Thomas J · Wilmington, NCN1920VTruluck Charles Harry III · North Fort Myers, FLN1925VNewell Robert J Jr · Belleville, MIN1926VVeenstra Timothy S · Wasilla, AKN1927VBoydston Terry · Whitewater, WIN1928NNikkila John C · Surprise, AZN1928VSchubert Christopher P · Canandaigua, NYN1935NAscolese Michael J · Athol, MAN1938VBarnett Jeffrey S · Clayton, INN1939VWheadon William J · Napa, CAN1940VGregg Delvin K · Durango, CON1944NNentwick James L Jr · East Liverpool, OHN1945NCochran Clifford D · Soldotna, AKN1945VKellar John C · Runaway Bay, TXN1947VKlenske Joshua Mark · Yucaipa, CAN1947ZPanzer Jessica DBA · Lincoln, NEN1948VBryant Mark A · Bennett, CO
Back to AD 48-07-01