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.
N3938PSwoboda Matthias W · Green Bay, WIN3938QGreen Carl P · Columbia, MSN3938WAugust Aero LLC · Kalispell, MTN3938ZCooper Donald A · Casper, WYN3939DRed Baron LLC · Middletown, DEN3939GThree Niner Gulf L L C · Denver, CON3939KRegistration Pending · Grand Prairie, TXRegistration pendingN3939RReid Edwin G Jr · Hollywood, MDN3939TDespins David R · Gray, MEN3939XArapahoe Flight Club LLC · Colorado Springs, CON3939ZCarnine Daniel · Angora, NEN393AWRoe Elton L · Harrison, ARN393BThickstun Benjamin Tyler · Wasilla, AKN393DNational Training 1 LLC · Wilmington, DEN393DMAlba Leasing Services LLC · Scottsdale, AZN393DW3 Delta Whiskey LLC · Superior, WIN393FBRegistered aircraftN393HWilliams Fred V · Reno, NVN393KPBeyers Dale A · Walworth, WIN393LSBourne George L · Universal City, TXN393MUsda Forest Service Fepp · Helena, MTN393MAVandelay America LLC · Newport Beach, CAN393NMAce High Helos LLC · El Campo, TXN393PSVein C Jason · Riviera Beach, FLN393RCBarnes Thomas M · Pittsboro, NCN393RVBell Paul E · Granbury, TXN393TIronhawk Aviation LLC · Indianapolis, INN393TBTom Brown Consulting LLC · Ave Maria, FLN393TCAnderson Kelvin W · Denver, CON393THDobesh Craig L · Granbury, TXN393TMAvion Acrobatico LLC · Waterloo, ILN3940KAir Ventures Flying School LLC · Smithfield, RIN3940MCondair Flyers Inc · Latham, NYN3940QN3940q LLC · Newnan, GAN3940ZGrasser Edward K · Palmer, AKN3941DOrchid Aero LLC · Lakewood, CON3941KHawkins Allan S · Lizella, GAN3942NFlying Services Inc · Wilmington, DEN3942QSullivan Donald Edward II · Edwards, ILN3942TAuburn Valley LLC · Farmington, MNN3942WLarkin Jason · Zeeland, MIN3942YBender Andrew J · Greenwood Lake, NYN3942ZHigh Exposure Inc · Wilmington, DEN3943Nighthawk N8231g LLC · Pompano Beach, FLN3943DLoudan Christopher D · Trinidad, TXN3943WCox Aviation LLC · Debord, KYN3943XSuberg Valerie G · Windsor, CAN3943YStuart Leslie Trustee · Roseburg, ORN3944FHenley Johnny · Trenton, NCN3944KPeiker Laramie · Revillo, SD
Back to AD 2007-04-19 R1