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.
N1672VKott Edward A · Lake City, FLN1682VShuck Michael W Trustee · Maize, KSN1685VCreglow Jacob A · Soldotna, AKN1686VByers Ricky A · Hereford, AZN1695VAircraft Guaranty Corp Trustee · Oklahoma City, OKN1696VRonnau Thomas F · Kansas City, KSN1703NEvans Richard H Sr · Holt, FLFirst renewal noticeN1704VFigure 1 Foundation · Los Angeles, CAN1706VHermann Christine F · Radford, VAN1708UShelton Philip C · Wise, VAN1708VMock Paul M · Williams, AZN1710VWanda Collins Professional Pilot Services LLC · Madisonville, TXN1712NPinger Kevin R · Palo Alto, CAN1715NGerzevitz Robert M · San Diego, CAN1717NDagenhart Kagan · Midland, TXN1720VEdmonds Sherry B · Georges Mills, NHN1721NWood Bokman Janine · Athol, IDN1721VCollins Gary C · Asheboro, NCN1722VLittle Bird Aviation · Abiquiu, NMN1724NTurcott Joshua A · Stockton, CAN1726NGranneman William L · Costa Mesa, CAN1726VBosquet Arthur · Highgate Center, VTN1728VMoore Edward L · Hixson, TNN1731VHargrove Dwayne E · Shepherdsville, KYN1741NAero Optics Inc · Aguila, AZN1741VCollins E Randolph · Clemson, SCFirst renewal noticeN1745VReinholtz Edward J · Glasford, ILN1746NSmith Courtney E · Phoenix, AZN1748NTengesdal Kenneth L · Maxbass, NDN1751NTynes Edward R · Round Rock, TXN1751VScott William G · Lebanon, ORN1754NMorrison Rodney R · Hot Springs, ARN1755VMcclean James · Springfield, MON1757VMollohan Timothy J · Otis, CON1758NMclaughlin James L · Centerburg, OHN1761NNewcomer Ryan D · Monroe, GAN1761VMoyer Michael R · Elkton, MDN1766NStevens William · Nassau Bay, TXN1767VHanson Jonathan G · Nome, AKN1770NWirth Curtis L · New Raymer, CON1771NRohsner Thomas A · Nacogdoches, TXN1773NRhoades William P · Northfield, MNN1773VGilbert Mary L · Memphis, NYN1775NPritchard Joshua E · Andover, KSN1776VNelson Richard W · Edna, TXN1778VWatkins James R · Granbury, TXN1783VMark Uhlman Dpe LLC · Perry, OKN1784VHarlow Nathan D · Milton, VTN1786NLivingston Lyle R · Chico, CAN1788NLahti Matt · Waterford, MI
Back to AD 48-07-01