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.
N292REStructure Inc · Neenah, WIN292RGWashington Road Associates LLC · Dover, DEN292RMJunk Troy A · Wshngtn Ct Hs, OHN292RSValiair Limited Company Trustee · Casper, WYN292SPMonmouth Aircraft Service Inc · Toms River, NJN292TRitsch Daniel C · Eagle, CON292TCRich Daniel W · Norton, MAN292UTecnam U S Inc · Sebring, FLN292VSandaric LLC · Wittman, MDN292VFTextron Aviation Employees Flying Club Inc · Wichita, KSN292WRabbitt Timothy N · Austin, TXN292WCColorado Mesa University · Grand Junction, CON292WYKasling Jonathan · Austin, TXN292YLaurie Kip · Atlanta, GAN29307Lacroix Michael G Trustee · Shorewood, MNN2930EKelly Ronald T Jr · Munhall, PAN2930FWrucke Scott · Horicon, WIN2930LSantana Maria M · Pearland, TXN2930RSouthern Warriors International Inc · Port Saint Lucie, FLN29310Talbert James D · Alamogordo, NMN2931AStrategic Aircraft Management LLC · Fairbanks, AKN2931EHoward Charles O · Sonoma, CAN2931HAtp Aircraft 7 LLC · Wilmington, DEN2931XRegistered aircraftN2931YWiesner Norman P Trustee · Silverton, ORN29320Triple G Aviation LLC · South Point, OHN29321Render Jeff · Peoria, ILN29329Hill Edward J Jr · Dover, DEN2932AHenderson Steven A · Idaho Falls, IDN2932FIceman Holdings LLC · Greer, SCN2932LBcs Aviation LLC · Dothan, ALN2932WSchweller Ronald L · Wilmington, OHN29330Rucinski Edward A · Climax, NCN29334Burger Cale L · Hampden, MEN29335Sale Reported · Lebanon, ORSale reportedN2933AFlying Particles Inc · Livermore, CAN2933FLevinsohn Reuben D · East Lansing, MIN2933VJones David T · Las Vegas, NVN29340Hodges Michael T · Myrtle Beach, SCN29343Aeromech Incorporated · Mukilteo, WAN29344P & P Aviation LLC · Trout Run, PAN29345Bailey Daniel L · Gibsonville, NCN2934ADixon Devin M · Las Vegas, NVN2934FH & S Aviation LLC · Roseville, MNN2934GHackwell Matthew C · Enoch, UTN2934YOwens John A · Granville, OHN29350Cardinal Flyers LLC · Amherst, VAN29356Rohwer Celia · Fairbanks, AKN29359Cervantes Jose DBA · San Diego, CAN2935CSuez Jose F · Tracy, CA
Back to AD 2007-04-19 R1