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.
N41352Custom Ppg Inc · Browns Summit, NCN41357Air Trek North LLC · South Saint Paul, MNN41359Ayubi-Moak Jason S · Chandler, AZN4135BBice Christopher S · Summerville, SCN4135DChristiansen Aviation LLC · Wilmington, DEN4135JValiair Limited Company Trustee · Casper, WYN4135SRazzyfish Inc · Colton, CAN4135TNehls Chevrolet Olds Cadillac · Marshall, TXN4135WTexins Flying Club · Mckinney, TXN4135YMoore Steven J · West Ossipee, NHN41361Excell Air Filters LLC · Ashland, OHN41362Bird Dog N41362 LLC · Midland, TXN41364Registered aircraftN41369Ascent Aviation Inc · Van Nuys, CAN4136ENelson Gregory A · Anchorage, AKFirst renewal noticeN4136PN4136p LLC · Titusville, FLN4136XSouthern Cross Aircraft LLC · Fort Lauderdale, FLN4136ZBrazit LLC · Miami, FLN41372Gorham Raymond A · Lock Haven, PAN41376Berkshire Aviation Enterprises LLC · Great Barrington, MAN41379Dzedzy Theodore Andrew Jr · Schwenksville, PAN4137BWalker James D · Grapevine, TXN4137CN4137c Inc · Redwood City, CAN4137LLuv 2 Fly Ada LLC · Ada, OKN4137MKropf Flying Service LLC · Harrison, ARN4137SBurns Craft LLC · Wilmington, DEN4137YMurray Robert Scott · Franconia, NHN4137ZAtg Enterprises Inc · Aztec, NMN41380Aristizabal Leonardo · Woodland Hills, CAN41383Lamontagne Bradley Theodore Jr · Pleasant View, TNN41387Horizon Aviation LLC · Brooks, GAN41389Johnson David C · Chisago City, MNN4138GUtah State University · Logan, UTN4138HMiller John A · Ballston Lake, NYN4138JRegistration Pending · Orlando, FLRegistration pendingN4138PFreyburger Gregory P · Strykersville, NYN4138QSteward John A · Atlanta, GAN4138TLindquist Holdings LLC · Noblesville, INN4138XBroadwell Eric B · Woodstock, GAN4138ZZweifel Douglas L · Anchorage, AKN41391Aurora Aviation Lc · Pierce City, MON41395Vera Aviation LLC · Mountain Home, IDN41399Beck Paul R · Knoxville, IAN4139JWolles Joseph · Dell Rapids, SDN4139RPilot Mountain Aviation LLC · Pilot Mountain, NCN4139ZL Sheffels And Son Inc · Wilbur, WAN413AAAmerican Aviation Inc · Brooksville, FLN413AMCosmic Kid LLC · Alpine, WYN413BBRegistration Pending · Iron Station, NCRegistration pendingN413BMLee Aviation LLC · Sheridan, AR
Back to AD 2007-04-19 R1