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.
N3657NEstes Aviation LLC · Vicksburg, MSN3657QFaith Builders Family Church Inc · Rogers, ARN3657YSims Daniel G · Martinez, CAN3657ZBagdon Albert B · Elbert, CON36583Pray Aviation Inc · Augusta, KSN36588Moseley Richard W · Lakewood Ranch, FLN3658WFlying 20 Club Inc · Springfield, ILN3658YJo Co Inc · Knoxville, TNFirst renewal noticeN36590American Aircraft Sales LLC · Lincolnshire, ILN36593Kentucky Stick And Rudder Academy LLC · Springfield, KYN36594Hayward Casey W · Anchorage, AKN3659CWhite Paul S · Clarksville, TNN3659KDumont Mark · Brush Prairie, WAN3659MTrent Daniel E · Las Vegas, NVN3659RInternational Air Services Inc Trustee · Carson City, NVN3659XAiello Bailey H · Eugene, ORN3659YPeterson Laurel R · Hart, MIN365ACEvalidate LLC · Birmingham, MIN365BMiles Barrington K · Austin, TXN365BSHarders Justin M · Cairo, NEN365CB.R.S. Leasing Inc · Wilmington, DEN365CACivil Air Patrol · Maxwell Afb, ALN365CCSki Sawmill Family Resort Inc · Ulysses, PAN365DAJeffries Ian Mcgoff Douglas · Clover, SCN365DBRutan Aircraft Flying Museum · Waller, TXN365DLSoehner Harold D · Winslow, AZN365DRPace Ryan · Morgan, UTN365FCRegistration Pending · Kalispell, MTRegistration pendingN365HStavair LLC · Gulf Breeze, FLN365MADip Aviation LLC · Fort Lauderdale, FLN365MEEhnisz Craig T · Monterey, CAN365MKNorth Star Aviation Inc · Mankato, MNN365MSMaloney Leasing LLC · Tupelo, MSN365NGReid Michael V · Sulphur Springs, TXN365PARotor Leasing LLC · Indianapolis, INN365PCWings Over Texas Holdings LLC · Denton, TXN365PSFainer Jeffrey M · San Diego, CAN365RVTwin Oaks Aviation Inc · Pipersville, PAN365RWWalter Aviation · Perry, IAN365SBClear Skys LLC · O Fallon, ILN365SPClow International Airport LLC · Bolingbrook, ILN365TGengarelly Robert M · Benson, AZN365USTecnam US Inc · Sebring, FLN365WCCrane Douglas F · Ukiah, CAN36601Frett Dennis R · Windsor, MON36602B2 W Corporation · Winona, MNN36603J&J Holdings Of Pella LLC · Pella, IAN3660RBackcountry Wings LLC · Gig Harbor, WAN3661Mckenna Kent T · Torrance, CAFirst renewal noticeN36615Booth Warren Russell · Doylestown, PA
Back to AD 2007-04-19 R1