AD 72-03-03 R3
Registered aircraft · 17,027
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:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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.
N50110Coger Charles E · Huntsville, ARN50115Affordable Flight Time LLC · Eagle River, AKN50118Carver Alan H · Winder, GAN50131Kotval Matthew J · Milaca, MNN50132Dunaire LLC · Mechanicsburg, PAN50133Pilot Legal Funding Inc · Fresh Meadows, NYN50138Kalb Brian A · Mechanicsburg, OHN50140Air Devices Company LLC · Alpena, MIN50146Aero Sceince International LLC · Martinez, GAN50150Above All Aviation Inc · Santa Barbara, CAN50151Thums April M · Murfreesboro, TNN50155Haupricht Andy C · Sanford, NCN50156Humanic Thomas J · Columbus, OHN50160Morales-Escareno Rogelio · San Diego, CAN50170Moroney Aviation LLC · Chugiak, AKN50171Evans Mark E · Heber Springs, ARN50177Dudley Lee B · Passadumkeag, MEN5017UBen Allen LLC · Wilmington, DEN50180Robbins Richard T · Ketchikan, AKN50181Debelius Enemark Peter C · Crawfordville, FLN50184Wietecha Jack · Millington, ILN50188Ryburn Michael D · Basehor, KSN50194Brouillette Jakob D · Daleville, ALN501DSChilson Jacob Shane · Willits, CAN501GEPhillips Matthew D · Astoria, ORN501NGCummings Johnny R IV · Clearwater, FLN50201Ahrens Brian T · Hainesport, NJN50202Velasquez Jorge · Brawley, CAN50205Spruce Moose LLC · Salt Lake City, UTN50209N Maple LLC · Kalispell, MTN50213Canarr Randall J · Anchorage, AKN50219Sftb LLC · Miami, FLN50221Smith Wayne A · Uxbridge, MAN50222Baldwin Kevin R · San Tan Valley, AZN50224Reshetar Ryan D · Evansville, INN50231Aaronflight LLC · Hillsboro, ORN50232Firby John E · Diamond, OHN50234Lloyd Barry C · Sacramento, CAN50245Christian Martha J · Ham Lake, MNN50251Featherston Nicholas L · Chandler, AZN50252Price Benjamin A · Hattiesburg, MSN50255Andrews Michael E · Huron, OHN50258Willis Walter W · Kamiah, IDN50261Copeland Joey A · Douglas, GAN50262Garrison Vincent Gray · Yadkinville, NCN50263Registered aircraftN50266Plentl Steve R · Shepherd, TXN50267Buckner Natasha · Locust Grove, VAN50268Mach Steven William · Chicago, ILN50269Joerger Dannie L · Greensburg, IN
Back to AD 72-03-03 R3