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.
N316NFSteenland Mark R II · Killeen, TXN316PAkin Products Inc · Monticello, ARN316PABird Acquisition LLC · Phoenix, AZN316PBDavison David D · Ponte Vedra, FLN316PHMoon Hill Farm LLC · Kirkland, WAN316RALeading Edge Flight Services Inc · Hampshire, ILN316RWFour States Tire & Service Inc · Cortez, CON316SDHamilton Scott Richard · Fort Worth, TXN316SFDoc Aviation LLC · Ponca City, OKN316SKKoch Charles S · Prospect, KYN316SMGilland Mark J · Stuarts Draft, VAN316STBig Daddys Casinos Inc · Huntington, WVN316TCEmerald City Aircraft Leasing Inc · Port Orchard, WAN316VUpstate Sc Flyers LLC · West Union, SCN316WVShearer James D · Jacksonville, FLN316XKinney Shawn M · Camp Verde, AZN316ZAlpha Tango Aircraft LLC · Wilmington, DEN31700Ratcliff Bruce A · Plain City, OHN31707Bankruptcy Services LLC · Wilmington, DEFirst renewal noticeN31708Albatross Air Inc · Beaver, WVN31709Pace Richard · Leighton, ALN3170FO'Neill Matthew · Indianapolis, INN3170QRenfrow Denny · Kelseyville, CAN3170UHarrison Brian C · New London, OHN3170YStillson John L · Rock Rapids, IAN3170ZGarrity Frank B · Durham, CAN3171Derr Matthew R · Frackville, PAN31715Brereton Mark C · Lineville, ALN31716Metro Aircraft Co · Bloomington, MNN3171CLand Sea & Air Inc · North Mankato, MNN3171DJohnson Donald B · Lino Lakes, MNN3171EJprg Aviation Inc · Orlando, FLN3171FRockin Rt LLC · Smithfield, UTN3171HKh Air LLC · New London, MNN3171QLynn Aviation LLC · Wilmington, DEN3171TVanlandingham Michael E · Oxnard, CAN3171YDj Aviation LLC · Newburgh, INN31721Needler Toby · League City, TXN31724Apostolic Fellowship Assoc · Clearwater, FLN3172DNorth State Aviators LLC · Cary, NCN3172EKruchten Larry A · Scottsdale, AZN3172KAnderson Stephen · Loveland, CON3172SSterling Flyers LLC · Lehi, UTN3172YPeters Barry S · Montague, CAN3172ZSpitzer Anthony L · Kalona, IAN31734Oscar Air LLC · Bethlehem, PAN31736Lees Sea Air · Kiana, AKN31737Scs Construction LLC · Cape May Ch, NJN31739Aircraft Guaranty Corp Trustee · Oklahoma City, OKN3173CMcgaha Justin L · Hooker, OK
Back to AD 2007-04-19 R1