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.
N5023RStern Joseph L · Morrow, OHN5023SSummit Arrow Adventures LLC · Peyton, CON5023YAas LLC · Ovid, MIN50240Carr James T · Scotts, MIN50246Taubman Jason · Greenland, NHN50247Haywood Charles E Jr · Valrico, FLN5024DGordon Glen M · Corning, CAN5024PSun Aviation Inc · Santa Clara, CAN5024SGuy Timothy S · Henderson, NVN5024TMoore Jason J · Spanish Fort, ALN50259Coker Steve L III · Tyler, TXN5025BHayes David A · Steward, ILN5025CSamalon William S Trustee · Juneau, AKN5025DCal-Aerofab Flight Academy Inc · Chino, CAN5025EStokes Field LLC · Mount Vernon, MON5025FAllen Scott L · Ogallala, NEN5025PFoley Jeffrey W · Scappoose, ORN5025QAppel Joshua D · Redfield, SDN5025SAir Cover Academy LLC · Frankford, MON5025TRoney William A · Santa Fe, NMN5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLN5026AMartin Kent D · Pittsburg, TXN5026BLaurie Craig M · Anchorage, AKN5026DRoss George W · Boise, IDN5026ETurner Greg W · Delta Junction, AKN5026GJohnson Steven L · Salol, MNN5026NWright Bruce M · Rosharon, TXN5026RSwinney Marty Sherman Trustee · Macomb, OKN5026UBorders Nowell Equipment G P Inc · Edinburg, TXN5026VPiland Kenneth Eldon Jr · Carlsbad, CAN5026WSpencer Don W · The Dalles, ORN50271Sawyer Johnson Inc · Osceola, WIN5027DTucker Austin L · Spooner, WIN5027EMeister James E · New Richmond, WIN5027FAmoia Steven M · La Mesa, CAN5027KMchale Thomas Alexander II · El Paso, TXN5027NMargolin Donald B · Santa Barbara, CAN5027RVentura Hector E · Vieques, PRN5027SRatliff Thomas E · Tomball, TXN5027TMohre Steve G · Blakeslee, OHN5027WJohnson Dennis E · Factoryville, PAN5028DSanders Jess E · Troy, MTN5028FMarshall Kevin · Dekalb, ILFirst renewal noticeN5028GButler Patrick F · Elko, NVN5028LBarla Joel · Eaton Rapids, MIN5028RSmith Ray C Jr · Sault Sainte Marie, MIN5028SSmith David J · Elkhart, INN5028TDrake Charles R · Claremore, OKN5028VFlying Lemur Inc · Alexandria, VAN50291Euros Aircraft Leasing LLC · College Station, TX
Back to AD 2007-04-19 R1